Postgresql Connector

[michelle_low]

Hi there,

I have been connecting to Heroku postgresql using ODBC but I would like to auto refresh daily without setting VM.

Apart from azure, what other affordable postgresql provider (prefer low cost) that Powerbi postgrsql connector can connect directly without ODBC?

Thanks

[Anonymous]

Hi @michelle_low ,

I have also found a similar post , please refer to it to see if it helps you.

Solved: Power BI Desktop ODBC Connectors to PostgreSQL wit... - Microsoft Power BI Community

•  I used the standard Postgres Connector offered out the box, I installed this driver here:

  Release Npgsql v4.0.10 · npgsql/npgsql · GitHub

  I used the GAC method and everything worked.

Here is also a document, please refer to it to see if it helps you.

PostgreSQL To Power BI: 3 Best Ways To Connect - Learn | Hevo (hevodata.com)

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.