cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aukev Regular Visitor
Regular Visitor

PostgreSQL to Power BI Service without on premise gateway

We're looking into pushing our data into a cloud PostgreSQL database. Probably Azure PostgreSQL. We'd like to have an online dashboard/reports so we need to use the cloud version of Power Bi so that these refresh daily. I noticed that to be able to get data from PostgreSQL sources we need to run a Gateway. Seems this can only be done on-premise on a windows machine or windows server. This is not really an option for us.

Are there any solutions to get around this? Other suggestions?

 

BTW, we specifically chose PostgreSQL for financial reasons. I`m aware that Azure SQL and Azure Datawarehouse have apps to connect directly with Power BI Service but these are considerably more expensive.

5 REPLIES 5
Community Support Team
Community Support Team

Re: PostgreSQL to Power BI Service without on premise gateway

Hi @aukev,




Yes, the data gateway for power bi should be installed in 64-bit version of Windows 7 / Windows Server 2008 R2 (or later).

 

If you want to get data from PostgreSQL database in Power BI Desktop and publish the report in Power BI Service and then set the schedule refresh, you must install the gateway.

 

Here is a workaroud which may be helpful if your data is not very large.

 

If you cannot install gateway, you could try online data source. You could export your data in PostgreSQL database to excel and then upload the excel file in SharePoint. Then you could connect the excel in SharePoint in Power BI Desktop with web connector, it won't need you to install the data gateway for refresh.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aukev Regular Visitor
Regular Visitor

Re: PostgreSQL to Power BI Service without on premise gateway

Thanks. I was hoping there would be a more elegant solution. I`ll look into setting up a windows virtual machine to run the gateway from. Thanks.

aukev Regular Visitor
Regular Visitor

Re: PostgreSQL to Power BI Service without on premise gateway

Hi Cherry, a related question. If we where to use Azure SQL Database, would we need the gateway to refresh too or would that work out of the box?

Community Support Team
Community Support Team

Re: PostgreSQL to Power BI Service without on premise gateway

Hi @aukev,

 

Yes, If you use Azure SQL Database, that will be the online data source. 

 

For online source, we don't need to use configure the data gateway.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aukev Regular Visitor
Regular Visitor

Re: PostgreSQL to Power BI Service without on premise gateway

Thank you.