Forum Discussion
app.powerbi.com AWS RDS Postgres dataset
Hi all, We are moving to a Microsoft 365 E5 plan and I'm looking to bring Power BI Pro into our organization (because it's included with E5), but I'm running into issues connecting to RDS Postgres on...
- Hi there
In order to connect to the data, you will need to install an EC instance that has got network access to your PostgreSQL.
Once that is done you will then install the On-Premise Data Gateway and configure it to connect to the Power BI Service.
Once that is done, you can then create a data source in the Power BI Service which will then connect to the PostgreSQL
More details on the On-Premise data gateway can be found here: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
Hi there
In order to connect to the data, you will need to install an EC instance that has got network access to your PostgreSQL.
Once that is done you will then install the On-Premise Data Gateway and configure it to connect to the Power BI Service.
Once that is done, you can then create a data source in the Power BI Service which will then connect to the PostgreSQL
More details on the On-Premise data gateway can be found here: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
In order to connect to the data, you will need to install an EC instance that has got network access to your PostgreSQL.
Once that is done you will then install the On-Premise Data Gateway and configure it to connect to the Power BI Service.
Once that is done, you can then create a data source in the Power BI Service which will then connect to the PostgreSQL
More details on the On-Premise data gateway can be found here: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
We This doesn't seem to work. We have gateway installed on the same machine where also PBI Desktop is installed (latest version with npgsql package), and both manual or scheduled refreshes don't work with the same error about missing npgsql package.
Looks like it's missing somewhere on the MS hosts in the cloud
This is what I just did:
- Created an EC2 Windows Server as per here: https://community.powerbi.com/t5/Service/app-powerbi-com-AWS-RDS-Postgres-dataset/m-p/846692#M80851
- Installed the gateway on it: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources
- Installed npgsql, certificates etc on it as per here: https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
- Set up the gateway/datasource etc in Power BI Service
- Published from BI Desktop
- Seems to be working OK
