Forum Discussion

jeffwinchell's avatar
jeffwinchell
Advocate I
9 years ago

PostgreSQL Dashboard Refresh

My data is on an on-premises server running PostgreSQL DBMS.

 

I want a dashboard for a small number of key metrics. The data changes on average once every 5-10 minutes.

 

If a user has to press F5 or a refresh button to see data that changed from 5-10 minutes ago that is OK.

 

Can I do this with Power BI?

 

I've tried doing this, spent MANY hours on it, and with all the complexity and confusion with app.powerbi.com, power bi desktop, on premises gateway, on premises gateway personal, reports vs dashboards...it is way too much for me to figure out if I can do such a simple thing.

 

Can someone just tell me if this is a reasonably easy thing to do?

 

And if not, but I can get away with a simple periodic automated replication of the Postgresql data (it is small) into an on-premises SQL Servr, then I will do that.

Need Help

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi jeffwinchell,

    In your scenario, after you connect to PostgreSQL databases from Power BI Desktop, create reports and publish the Power BI Desktop file to Power BI Service. Then you can install gateway, and add the PostgreSQL data source(please see picture1). Configure a data refresh schedule,  so that you can use gateway to refresh your dataset in Power BI Service. In this way, each time you make changes in PostgreSQL data source, the changes will be reflected in dataset and reports in Power BI Service based on refresh schedule. If you want to see the changed data using a refresh button, you can click "Refresh Now"(picture2) of your dataset, for more details, please review the links given above.

    picture1

    Best Regards,
    Angelia