Data Refresh

[GraemeMitchell]

I have build a dashboard that shows each of our machines last hour of production (pcs per hour).  My data is stored in Azure, every hour the data is cleared from a few tables and refreshed with new data.  The dataset in PowerBi is a DirectQuery, with a refresh frequency of 15 minutes.  We use Chrome to display our dashboards, they are "non" interactive and just show the last hours pieces.  When I log into SQL Management Studio and see when the data was refreshed it is usually 3 minutes past the hour and this data wont change until 3 minutes past the next hour. 

What I am failing to understand is why my dashboard data doesnt update until 45 minutes past the hour.  I my refresh schedule is every 15 minutes then what am I missing?  I really only need to get the new once per hour, right after its been updated in Azure.

Does anyone have any ideas how this would be done?

[v-jiascu-msft · Accepted solution]

Hi @GraemeMitchell,

There could be a little delay. Please refer to the Note in power-bi/refresh-data#what-can-be-refreshed.

>>>When you configure a time for scheduled refresh, there can be a delay of up to one hour before it begins.

An easy workaround could be setting the auto-refresh of the browser tab to trigger a manual refresh which will bring back new data. The extensions for the auto-refresh is easy to find in Chrome.

Best Regards,

Dale

[GraemeMitchell]

I am guessing the auto-refresh option will change if I want to use the Publish to Web to show these as standalone dashboards.

I thought that PowerBI would allow us to move away from using SAP Business Objects Dashboard, it requires flash player and that is becoming a security issue

So if I Publish to Web, how does the refresh frequency work?

[v-jiascu-msft]

Hi @GraemeMitchell,

Frist of all, we should make the dataset up to date. Then the new data will be reflected in the "Publish to web" automatically. Please refer to power-bi/service-publish-to-web#data-refresh.

Best Regards,

Dale