Since Power BI Service does not work directquery with Postgresql in Amazon RDS

[FernandoJMM]

Hello,

From Power BI Desktop I have a connection with Postgresql in AWS RDS through directquery that works correctly.

However after publishing a report in Power BI Service I try to see it and it is not able to display the data.

After correctly activating the credentials Power BI Service does not show the report data and this error appears:

**********************************
Cannot load model
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please try again later or contact support. If you contact support, please provide these details.
Message: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'
Activity ID: b6bdc784-7739-470b-8f0e-cd63b3a7c18c
Correlation ID: b2af934c-25dc-e69e-d2de-e4fa6fc10d0d
Request ID: 5af89df8-b4c3-a020-a4d1-c5e9b60e9690
Time: Mon Apr 13 2020 14:36:51 GMT + 0200 (Central European Summer Time)
Service version: 13.0.12816.311
Client version: 2003.4.025
Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net/
*********************************

According to the latest updates it is not necessary to configure a gateway for a directquery or live connection.

Any suggestion about it ???

Thank you

[v-shex-msft]

HI @FernandoJMM,

I'd like to suggest you take a look at following document about integrating power bi with AWS RDS datasource:

Integrate Power BI with Amazon Redshift for insights and analytics 

In addition, have you used the encrypt credentials on your connector? Have you configured the whitelist for power bi service request ip list? They can also affect the connections.

Regards,

Xiaoxin Sheng

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".