Forum Discussion
Super UserDashboard tile from Direct Query/SSAS on-prem does not refresh
Microsoft EmployeeHi ToddChitt
It's a time reason by default.For further,please check if below workarounds could help.
For 3rd party Links:
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Regards,
Super UserHello v-cherch-msft Thanks for you quick reply.
Sorry, neither of those links helped. I don't plan on re-architecting my solution to use push datasets. It is currently in an Analysis Services Tabular model and we need it to serve up other reporting avenues in house. The other article mentions changing the refresh schedule of the dataset. But I don't have that option as it is direct query. I can't schedule a refresh.
It has been DAYS now, with fresh data getting processed regularly in the Tabular Model, and I can see that fresh data in a Power BI REPORT. But the DASHBOARD has not been refreshed.
So, other than the user having to MANUALLY click the REFRESH button on the page, WHAT ELSE might cause Power BI to refresh data on a Dashboard Tile that uses DIRECT QUERY? You mention a 'time reason'. What's the time frame?
Am I missing some setup or configuration option or setting, or is this a bug?
- ToddChitt
OK, I did stumble upon the Dataset Settings in Power BI (second article above) but some things seem out of sorts.
A) If you click on the elipsis next to the Dataset itself, you will see a popup message that says, "This dataset connects to a SQL Server Analysis Services Tabular database & is always up to date. You don't have to schedule a refresh on this dataset."
B) If you click the gear icon in the upper right corner, then select Settings, then select the Datasets page, and finally select the Dataset in question, there is a section for "Scheduled cache refresh" and you can select anywhere from 15 minutes to weekly. The default appears to be hourly.
So if I "don't need to schedule a refresh on the dataset", why do I have this setting for Scheduled cache refresh? These two things seem to be polar oposites. And why can I NOT access the Scheduled Cache Refresh option from the elipsis next to the dataset? That's a user experience letdown for sure.
I changed the Cache refresh window to 15 minutes and waited for the next cycle. The tile on the dashboard now seems to have refreshed on its own. Was that a fluke? Or was I just being too impatient? Would I see the same caching failures if the server was running 24/7?
I guess the test is to A) load the Tabular database with fresh data and process it, then B) wait at least 15 minutes, more like 1/2 hour, THEN check the numbers in the Dashboard vs. the Report. I'll try that in the coming days.
Looking further at the refresh history, I see that it records COMPLETED at several times this morning when my laptop (which hosts the Gateway and the SSAS Tabular database) was SHUT DOWN. There is no way it could have been completed because the database was off line. Please explain.