Forum Discussion
An exception occurred: Please install Npgsql version 4.0.10.0 or earlier.
You need a gateway, and you need to install the indicated PostGreSQL driver on the gateway. There is a well documented bug that the gateway installer is missing that driver. You need to borrow the driver files from your desktop setup and paste them into the ADO folder on the gateway.
Hi luqui_maps ,
Please refer to the following steps:
the PostgresSQL connector doesn't work out of the box, you need to do quite a few things first
1. Install Npgsql which allows .NET access to PostgresSQL. I installed it using the Pakagae Manager Console in Visual Studio; detailed instructions are here: https://www.nuget.org/packages/Npgsql/
You need to connect over SSL to AWS which isn't setup by default (on my Windows 10 machine anway)
2. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7/P7B)
4. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
5. Test access from Power BI desktop using the PostgresSQL connector and it should work
More details: Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community
Solved: AWS RDS Postgres refresh from PowerBI service - th... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Thank you for your prompt response.
The question was
"I dont have any problem to use ODBC and Gateway.
But it's too slow."
So I would like to use "Native Query" to update the dashboard in Workspace automatically.
The problem is not using PowerBI desktop to update dataset.
The real problem is the following.
1. Native Query in Power BI Desktop Connect - Success
2. Updating Power BI Desktop to update dataset in my notebook - Success
3. Uploading PBIX file to Power BI Workspace - Success
4. Update dashboard in Workspace by using automatic or manual update - FAIL
The error message :
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.'
How to fix the #4 ?
Regards,
Lucas
Super UserAs I said you need to install the ADO drivers on all gateway cluster members.
How can I install the ADO drive at PowerBI workspace (Azure) ?
I dont have any direct access to Power BI Workspace.
Can you explain it?
- lbendlin
Not in the workspace, in the gateway cluster VMs.
If I install the ADO drive in the gateway cluster VMs, I can update in workspace by using schedule update?
As I mentioned above, I can update and connect to dataset by using direct query thru PowerBI desktop.
My question is the second one.
Update thru ODBC in Power BI Cloud Workspace : success
Update thru Native Query in Power BI Cloud Workspace : fail.