Cannot load model to PBI Service with PostgreSQL DB

[PatrikM]

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 !

[GilbertQ]

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]

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!