Cannot Load Model

[rickygalang]

hi...

I create a report on Power BI Desktop with data sources from postgree via direct query safely without any problems.

Then I published it to Power BI Service, and I also set it to manage connections and also ensure that the connection is online.

But when I want to open the report in Power BI Service, the report cannot be opened with an error:

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please check the technical details for more information. If you contact support, please provide these details.

Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError
QueryUserError: The PostgreSQL source doesn't support encrypted connections. (Source at 45.13.132.226;db_2_2.). The exception was raised by the IDbCommand interface.
Correlation ID: 40551d63-7ac1-cd65-2149-1fb2662658f1
Activity ID: 665851b8-9f8e-4047-92ce-f906bd57cee3
Request ID: 181262a2-bbb7-179e-da53-8ef5b60cd957
Time: Sat May 13 2023 09:12:47 GMT+0700 (Western Indonesia Time)
Service version: 13.0.20626.62
Client version: 2305.1.13619-train
Cluster URI: https://wabi-south-east-asia-b-primary-redirect.analysis.windows.net/

[GilbertQ]

Hi @rickygalang 

From the error message it is saying that you need to connect via a standard connection with Encryption disabled. 

[rickygalang]

what is the connect via a standard connection?
I have connected to postgree using a user and password that is not encrypted
sorry, I still don't understand that

[GilbertQ]

Hi @rickygalang 

If you have had it working before, I would suggest comparing between the 2 databases to make sure all the settings are the same?

[rickygalang]

I mean, the connection to postgree is set up like that, there is no encryption, and it works fine on desktop Power BI, when I publish to Power BI service, the report can't be opened

is there any solution for that?