Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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.
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?
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
The solution here does not really sound good enough. Why can't one use Azure Database for PostgreSQL server as an online data source for the Power BI service? or I am not getting the gist of things. I found myself in a similar situation and I want to be able to use the power BI service for direct querying to the database without constantly refering back to Powert BI Desktop.
Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.