Config Power BI Gateway

This is a note when I config Power BI Gateway. Datasource is Postgres and I want to publish to Power BI Web.

First, Power BI Gateway need to run on 64-bit version of Windows 10 or a 64-bit version of Windows Server 2012 R2.

Then, Install Power BI Desktop to build your test report and publish to Power BI web.

To Install Power BI Gateway follow this Document.

Install an on-premises data gateway

Check your Gateway by login to https://app.powerbi.com

Setting > Manage connections and gateways

You will see your gateway in a list.

After install Gateway, you need to install Npgsql to use Postgres with this Gateway on Power BI web. You can download msi file from link below

https://github.com/npgsql/npgsql/releases/download/v4.0.13/Npgsql-4.0.13.msi

Releases · npgsql/npgsql

The following is the link I follow to fix this problems.

Power BI Gateway error when connecting to PostgreSQL fix

After install Npgsql, you need to restart Power BI Gateway.

Create Report in Power BI with Your postgres datasource.

Note. I didn’t use encryption so I had to change in Datasource setting. This is my test env, you may not need to do this.

Try something with your report with your postgres database then save and publish.

Then, Go check at Power BI web.

Create New Connection with your Gateway.

Config your gateway in your datasource in report.

Select your gateway.

Then goto your report and view. I hope this work for you.