Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PatrikM
New Member

Cannot load model to PBI Service with PostgreSQL DB

Hello everyone, please share your thoughts on this issue. I am connected to PostgreSQL database through connector in directquery mode. Connection works fine in Power BI Desktop, but after publishing model to PBI Service it shows me this error and I Am unable to see visuals. 

PatrikM_0-1668961837541.png

In Power Query I have turned off privacy and security levels and unchecked encrypted connection. I have contacted admin of databese about this issue and he told me, that database has no ssl certificates. I am assuming that PBI Service requires some kind of certificate, but I Am not sure what is the root issue. 

 

I was able to resolve this issue with ODBC connector, but it does not support directquery mode.

Thank you very much for your advice !

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @PatrikM 

 

It is because you need to have a certificate running on the on-premise gateway.

 

As far as I know you should be able to use DirectQuery with PostGreSql and ODBC

 

As you can see from the list below it is supported: Power BI data sources - Power BI | Microsoft Learn

 

I would suggest trying to set up the Power BI Desktop with ODBC and DirectQuery from a new PBIX and see if that works?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ, thank you for your answer. 
I have one model connected through ODBC and active gateway, which works fine, but I do not see options to choose import or directquery as it is in native PostGreSQL-Power BI connector. 
ODBC connector that I Am using looks like this: 

PatrikM_0-1669023592589.png

After input of credentials connection works, but only in import mode. So that is the reason why I am trying to use native connector, which provides directquery mode. Am I missing some other options how to set up ODBC connection in directquery mode? 
Ps: Another thing that bothers me with ODBC connection is that the gateway must be turned on to succesfully refresh published dataset in Power BI Service. 

Thank you!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors