Forum Discussion
Cannot load model to PBI Service with PostgreSQL DB
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?
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!