Forum Discussion

aukev's avatar
aukev
Icon for Helper III rankHelper III
7 years ago

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.

Need Help

7 Replies

  • epresson's avatar
    epresson
    Frequent Visitor
    6 years ago
    Hello has there been any other progress on this topic? I have the same question, why is an Azure Postgresql DB not considered as an online/cloud source? Why do I need to use a gateway to download my data from the Azure DB just so it can then be forwarded to the cloud again via PowerBi Service?
  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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

    • aukev's avatar
      aukev
      Icon for Helper III rankHelper III
      7 years ago

      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's avatar
        aukev
        Icon for Helper III rankHelper III
        7 years ago

        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?