DEV Community

loading...

Connecting Power BI to PostgreSQL on Azure

mattdyor profile image Matt Dyor ・1 min read

If you want to connect your desktop Power BI to a SQL Server on Azure, it is a pretty simple couple of clicks. PostgreSQL takes a couple of additional options.

  1. On your Windows machine, click on Windows > ODBC Data Sources (32 Bit)
  2. Click on the Drivers tab to make sure you have the PostgreSQL ODBC Driver
  3. Click on the User DNS tab and Add a connection to the PostgreSQL ODBC Driver (I used the Unicode driver, but I am not sure if that is required)
  4. In Power BI, click on Get Data (the top of the icon, not the drop down - if you click the drop down you need to select More...)
  5. Search for ODBC
  6. You should see the Data Source Name you just created as an option. I don't think you need to specify Advanced Options, as the DNS has all of this information.

You are now ready to pull data into Power BI from your Azure-hosted PostreSQL database (and this would probably work on platforms other than Azure as well, but I have not tested them out).

Cheers.

Matt

Discussion (0)

pic
Editor guide