Forum Discussion
PostgreSQL Dashboard Refresh
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
It seems to me that the most frequent the scheduled refresh does is once a day. Does anyone see anything differently?
If so, that is not nearly frequent enough.At this point we seem to have two options:
1. replicate the data more frequently to a SQL Server database (which can get much more closer to real time data) and then connect that database to Power BI.
2. hack via webscraping and a scheduled repetitive task, the Refresh Now button so that I can automate the pushing of that button on a frequency we need
Does anyone see any other options?Hi jeffwinchell,
Until now, the refresh schedule can not support the custom times refresh. Please vote the following ideas.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19389373-customized-scheduled-refresh
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11608869-hourly-refresh
Best Regards,
Angelia
Now Power BI supports customized refresh schedule option.
