Forum Discussion

MelissaSnell's avatar
MelissaSnell
Helper I
10 years ago
Solved

PowerBI desktop - PostgrSQL data seems to load in Query Build but fails to load in Report Builder

This is a bit of a weird one. I am trying to use PowerBI desktop to generate reports based on a PostgreSQL database. I am on a Windows 8.1 Professional laptop and I followed the instructions to mak...
Need Help
  • MelissaSnell's avatar
    MelissaSnell
    10 years ago

    UPDATE: Upgrading the npgsql DLL to the latest release 3.0.1 seems to have resolved the issue.

    https://github.com/npgsql/npgsql/releases/tag/v3.0.1

     

    In case it helps anyone I created a dummy project in Visual Studio 2012 and installed the package using nuget.

     

    I then copied the DLL out to a different location and used the Visual Studio Developer command prompt to uninstall the existing DLL from the GAC and then install the new one.

raghu_91's avatar
raghu_91
New Member
10 years ago

hi,

 

Can someone please tell the steps that needs to be done to connect postgresql.

 

I am geeting the error the download npgsql, which I did but I dont know the further steps

MelissaSnell's avatar
MelissaSnell
Helper I
10 years ago

See if this helps:

http://www.postgresql.org/message-id/[email protected]

 

I found I needed to look on this site for how to use .NET to access PostGreSql.

 

You need the right versions of mono.security and npgsql. Make sure you use the latest DLLs recommended because that solves a bunch of connection issues.

 

Let me know if you are still stuck and will try and give you more details if I get an email notification that you have replied