Forum Discussion
Dashboard tile from Direct Query/SSAS on-prem does not refresh
v-cherch-msftThat post describes the issue, but does not do much in explaining WHY it happens, or how to rectify it. The post is almost three years old. I would have expected Microsoft to have figured this out by now.
Is it possible this is because the SSAS Tabular instance and the Gateway that connects is are running on my local development machine, and as such are not connected to Power BI Service 100% of the time?
But when the machine IS connected, pulling up the Dashboard should run the Direct Query for each of the tiles, does it not? I'm going to say, "No" to this because with the SSAS disconnected, I still see numbers.
Seriously, I see this as a BUG!. The Dashboard Tile MUST AT ALL TIMES report the SAME NUMBER as the REPORT TILE from which it came (assuming same filter context, etc.) The fact that it caches data is just WRONG, especially with DIRECT QUERY. If I STOP the Analysis Service on the laptop, then the Report tiles show ERRORS, as expected since it is DIRECT QUERY. But the Dashboard tiles STILL SHOW NUMBERS.
How do i STOP Power BI from doing this caching business?
Hi 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,
Hello 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?
