Forum Discussion
Do the Power BI report server certify direct-connect with postgreSQL and ODBC with postgreSQL
Do the Power BI report server certify direct-connect with postgreSQL and ODBC with postgreSQL? The desktop version has menu to load PostgreSQL data source and appeared the following dialog, installed the additional components from https://github.com/npgsql/Npgsql/releases but issue still reproduced. If we use connect postgreSQL via ODBC it appeared error when publish to BI report server. "We can't publish this Power BI Desktop report because it contains an unsupported data source connection or embedded data. This preview version supports only Power BI desktop reports that connect live to SQL Server Analysis Service (on-premises)."
1 Reply
- mgmeyer
Power BI Team
Based on your description it looks like you are trying to publish a report with an embedded model which isn't supported yet; PowerBI Report Server only supports connecting to external Analysis Services databases either on-prem or in Azure. We're currently working on embedded model support and it will be available in an upcoming release but for now you need to recreate you model inside Analysis Services and connect your report to it.
