Dashboard tiles not updating with Direct Query and On Prem Gateway

[daver1117]

I am having problems with Direct query. I have a SQL server on prem database and an On prem Gateway configured. I was able to create the report needed using Direct Query in Power Bi Desktop. I deployed the report to my online powerbi, pinned it to a dashboard and modified the Scheduled cache refresh settings on my dataset to every 15 minutes. The Refresh history shows that the data refresh is happening every 15 minutes with no errors, yet my report will not change results, even though the underlying database views are changing. I can get the results to update if I refresh my browser, or manually click the refresh database tile option in the service. I want to see that this dashboard will refresh on its own, so I can look to publish to wallboards around our office.

Any Ideas?

[v-yulgu-msft]

Hi @daver1117,

Based on my understanding, when we stay on a web page, it keeps the cache data which we currently see. Even the underlying dataset has been updated, the latest data won't be displayed on web browser because the web page is not reloaded. So, we need to manually refresh the web browser to view updated data.

Here is a similar thread which provides a workaround by adding extension to chrome which forces the page to reload at rates:

Auto Refresh Dashboards and Reports

Best regards,

Yuliana Gu

[icoletti]

We have the same setup (Direct Query and On Prem Gateway). I have scheduled refresh set for every 30 minutes, have manually refreshed the dataset, and cleared my cache... and the tiles are still not refreshing. I've even tried the solution with ?chromeless=true and that did not update the tiles even though the underlying reports are up to date. Would love a response/solution for this.

[daver1117]

Thanks Yuliana.

I understand. I was hoping that the refresh would happen automatically without the need for a whole page refresh/ chrome add-on. as a workaround, I wouldnt want users to see a full page refresh unless it was lightning quick. I know of other tools where refresh without full page reload is possible, and thought perhps Power BI would too.

Regards Dave