Forum Discussion

OzzyM91's avatar
OzzyM91
Frequent Visitor
3 years ago

Connecting Power BI Service to Local PostgreSQL

Hello,

First of all, apologies for asking such basic questions, but somehow I couldn't find any working solution anywhere in forums - I'm still a beginner so its possible I ran into actual solution without actually recognizing it.

 

I ran into an exception stating I'm supposed to install NPgsql 4.0.10.0, which I did install (from https://github.com/npgsql/npgsql/releases/download/v4.0.10/Npgsql-4.0.10.msi ).

 

My postgreSQL connection works smoothly in Power BI Desktop, and Ive succesfully used my data gateway to import .csv and .xlsx files already. Any tips on how to make DB connection work as well?

Need Help

1 Reply

  • arvindsingh802's avatar
    arvindsingh802
    Community Champion
    3 years ago

    You need to install the NPgsql 4.0.10.0 on gateway server similar to your development enviornment

    once done, please create a data source and use that for refreshing your dataset on service.