Forum Discussion

ecate's avatar
ecate
New Member
10 years ago

Connect PowerBI Desktop with PostgreSQL

I'm tring to connect power BI to a Posgres 9.4 database installed into the same machine (my windows 10 laptop). I've overcome the error about Npgsql intalling Npgsql.dll with GACutil and modifying t...
Need Help
Martin0342's avatar
Martin0342
New Member
7 years ago

Hi,

 

I've read all posts in this thread and I think I need to post an update:

 

It's 2019 and we still can't connect Power BI to PostgreSQL ;)

 

I've been trying to do it most of the day today and I am stuck. I've read through all materials I could find on the internet and installed all certificates/addons/plugins/drivers/you name it. And it still doesn't work!

 

I get this message when I try to connect:

 

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'System.Memory, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.'"

 

Does anyone know what else I could do?

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I think someone else at our organization had a similar issue.  The resolution was to download an earlier version of NPGSQL.  He had downloaded the latest version.  Everyone who has connected successfully is using version 3.27.  I would try that.