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.
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.
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.