| Feature | SeekTable (on-premise) | PowerBI Embedded (on-premise) |
|---|---|---|
| Live connection | SQL Server, MySql, PostgreSql, Amazon Redshift, Google BigQuery, Oracle, Showflake, ClickHouse, QuestDB, MongoDb, ElasticSearch, OLAP XMLA (Analysis Services), ODBC*
* with ODBC it is possible to connect to DBs that don't have built-in connector in SeekTable |
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 in generic ODBC connector. 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, Excel, Excel PivotTable, CSV,
JSON, Image
In Excel/PDF exports colors formatting is preserved. |
PDF, PowerPoint
PBI can export to CSV/Excel raw data if allowed. |
| Multi-page PDF exports | Yes | Yes
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), limit can be increased |
No expand/collapse for columnssource
No export to Excel/CSV (pivoted data) source 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: If you're interested in embedded BI functionality that is seamlessly integrated you can also check PivotData Microservice - this is SeekTable's reporting engine that is available as a standalone product. |