Forum Discussion

PatrikM's avatar
PatrikM
New Member
3 years ago

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. 

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 !

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    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?

    • PatrikM's avatar
      PatrikM
      New Member
      3 years ago

      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: 

      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!