Configure Postgres database credentials in Power BI Service

[Anonymous]

I have connected Power BI Desktop with Postgres using Direct Query mode, But when I publish it to Power BI Service. I'm unable to set data source credentials for scheduled refresh. I'm getting below error:

"Failed to Update data source credentials. An error happened while reading from the provider. The remote certificate is invalid according to valdation procedure." The same credentials works fine when connect with Power BI Desktop. Please find the screenshot of the error attached below:

Regards,

mohityash

[v-xicai]

Hi  @Anonymous  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[Anonymous]

I have checked all the points mentioned but its does not work. 

[v-xicai]

Hi @Anonymous ,

There are several points you may considerate:

1.Since your dataset contains the on premise data source, then it needs to use the gateway and configure schedule refresh, see more: :On-premises data gateway , Configure scheduled refresh .

2.Please make sure the gateway is online, and try to upgrade the gateway to latest version.

You might also try to upgrade the Power BI Desktop to the latest version . Download the pbix file from Power BI Service, then reopen in Power BI Desktop and republish to Power BI Service. See the similar case.

3.Ensure that you've added one or more data sources of your dataset to the gateway in Manage Gateway page, as described in Add a data source.

4.Verify that you have the correct username and password. Also, verify that those credentials can successfully connect to the data source. Make sure the account that's being used matches the authentication method.

5.Your data source credential may expire, so try to update the credential and republish the report. In Power BI, go to refresh settings for the dataset. In Manage Data Sources, select Edit credentials to update the credentials for the data source.

You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.