SeekTable vs PowerBI Premium Comparison for embedded reports

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
App view may be embedded for this purpose.
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
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
annual: $2,796
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.