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 ...
Need Help
jeffwinchell's avatar
jeffwinchell
Advocate I
9 years ago

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?