| Feature | SeekTable (on-premise) | PowerBI Embedded (on-premise) |
|---|---|---|
| Live connection (Direct Query) |
All databases, including:
SQL Server, MySql, PostgreSql, Amazon Redshift, Google BigQuery, Oracle, Showflake, ClickHouse, QuestDB, MongoDb, Sqlite, ElasticSearch, OLAP XMLA (Analysis Services), ODBC*
* with generic ODBC connector SeekTable can be connected to DBs that don't have built-in connector. |
SQL Server, Amazon Redshift, Oracle, PostgreSql, Google BigQuery, IBM DB2, Exasol, Vertica, SAP HANA, SQL Server Analysis Services, Azure Analysis Services
DirectQuery is NOT supported for: generic ODBC connector, MySql, MongoDB (SQL interface only). NOT supported (no native connector): ElasticSearch, MongoDB (native interface), ClickHouse, Sqlite. Taken from: Power BI data sources |
| Embed reports | Yes | Yes |
| Embed report builder
capability to modify reports by end-users and make ad-hoc queries |
Yes
App view may be embedded for this purpose. |
No |
| Report parameters | Yes | Yes |
| Row-level security | Yes
with JWT-based authorization, security context: user's context data is passed from the main (host) app |
Yes
security context: username, roles, datasets |
| Reports Deployment | All account data (cubes, reports, published reports) may be exported to XML-backup file.
Then, this XML file may be restored on production environment by the user with admin rights. XML file can be stored under version control; file is a human-readable and usual text diffs work just fine. |
PBIX (binary format, no way to get diffs under version control). |
| Export report formats | PDF, CSV, Excel, Excel PivotTable,
JSON, Image
All rows/columns may be exported (not only 'current page'). In Excel/PDF exports conditional colors formatting is preserved. |
PDF, Excel, PowerPoint (current page only)
PBI can export to CSV/Excel raw data if allowed. Export to Excel doesn't preserve conditional colors formatting. |
| Multi-page PDF exports | Yes | Yes (paginated reports)
paginated reports require PBI Premium |
| Pivot Tables | Rendered as HTML <table>
Same layout in web-view and PDF/Excel exports Server-side pagination for large matrixes Max size: up to 1,000,000 cells (columns x rows), this limit can be increased |
No expand/collapse for columnssource
Max size: up to 100 grouped columns x 500 rows source |
| Flat Tables (datagrids) | Web-view pagination is supported (prev/next or show-more)
Up to 50,000 rows at once. |
No pagination in table reports source
Up to 500 rows at a time source , large tables may be rendered/exported with PBI paginated reports |
| Charts | Basic charts: bar, horizontal bar, stacked bar, line/scatter/area, pie/donut.
Any custom visualization can be embedded with JSON data export and JS-code. |
Basic charts, maps, huge gallery of advanced charts source |
| Dashboards | Only canned dashboards developed with HTML/JS are possible | Dashboards may be created with UI |
| Price for self-hosted subscription
with white-labelling, paginated reports, no per-user licenses for viewers |
$233/month
annual: $2,796 |
$4995/month
annual: $59,940 (PowerBI Premium) |
Looks good? Learn more about SeekTable:
|