Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have been attempting to connect PowerBI to PostgreSQL, however I am receiving the error seen below.
I have followed the steps outlined below.
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)
Even after completing the following changes I am still receiving the error seen above.
Anyone else experienced something similar?
Thanks,
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
Have you installed the PostgreSQL Client in your PC?
Please refer to this blog firstly which introduce the detail steps.
In addition, if you still have this issue, you may try ODBC as a workaround. Please have a reference of this blog.
Best Regards,
Cherry