SeekTable vs PowerBI Embedded Comparison
| Feature | SeekTable (on-premise) | PowerBI Embedded (Fabric) |
|---|---|---|
|
Live connection (Direct Query) |
All databases, including:
SQL Server, MySql, PostgreSql, Amazon Redshift, Google BigQuery, Oracle, Showflake, ClickHouse, QuestDB, MongoDb, Sqlite, DuckDB/MotherDuck, ElasticSearch, OLAP XMLA (SSAS, icCube),
ODBC
*
* with generic ODBC connector SeekTable can connect to DBs that don't have built-in driver. |
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 (or only in PowerBI Desktop): ElasticSearch, MongoDB (native interface), Sqlite, DuckDB/MotherDuck. 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/font styles formatting are preserved. Up to 1,000,000 cells with values, this limit can be increased. |
PDF, Excel, PowerPoint (current page only)
Export to Excel doesn't preserve conditional colors formatting. Export limitations: CSV up to 30,000 rows, Excel up to 150,000 rows, pivot tables up to 150,000 data intersections. |
| Multi-page PDF exports | Yes (available for free users) |
Yes (multi-page reports / dashboards)
paginated reports require PBI Premium / Pro users |
| Pivot Tables |
Rendered as HTML <table> (styles can be customized with CSS!)
Same layout in web-view and PDF/Excel exports Server-side pagination for large matrixes Max size: up to 1,000,000 cells with values (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 a time, Excel export up to 1mln rows, CSV/JSON exports are suitable for 1+ mln rows. |
No pagination in table visuals, special paginated reports should be used.
Up to 500 rows at a time source. |
| Charts |
Basic charts: bar, horizontal bar, stacked bar, line/scatter/area, pie/donut.
Custom visuals with 3rd party JS libs are supported in dashboards. |
All basic charts, maps, a huge gallery of advanced charts source |
| Dashboards | Pre-configured by the IT team dashboards (defined with HTML template) | Dashboards may be created with UI |
|
Price
with white-labelling, paginated reports, no per-user licenses for viewers |
on-prem deployment for reports embedding: $233/month
annual: $2,796 |
Azure Fabric:
starts from $736/month (1 V-core, 3GB RAM)
annual: min $8,832 PowerBI Premium starts from F64 SKU ($5000/month with reservation). |
Looks good? Learn more about SeekTable:
|