I am having an issue connecting to my data source from the app.powerbi with the intention of having the data constantly updated. I want to connect to my data warehouse, which is in PostgreSQL. The error that I have is the following:
Failed to update data source credentials: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'
I managed to connect from the desktop APP, which I had the same problem but I solved it by turning off the encrypted connection because we do not use SSL and worked. I edited the following in the data source in PBI Desktop:
But then, in order to set the schedule refresh in the web app, I try to log in again to set it up and I have the issue again:
Is there a way to do the same that I did in PBI desktop but in the web app and disable the encryption or any other way to make this work?
Hi @matheuses ,
Please check if the solution in the following thread can solve your problem.
Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community
This is the related document, you can view this content:
Re: The remote certificate is invalid according to... - Microsoft Fabric Community
Solved: Invalid certificate 2020-07-13 - Microsoft Fabric Community
PostgreSQL Personal Gateway Data Source credential... - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!