Forum Discussion
Dashboard Tiles not refreshing with SSAS datasource behind
We have a dashboard where we pined many tiles from a report who he have a SSAS connection for datasource. Unfortunately, when the dataset is updated, the dashbord never refresh by itself. We must refresh it manually each time even if we wait 10 minutes.
Otherwise if we use the pinning a live tile, the refresh work. But, we lost some functionnality like mobile visual and link pour each pined tiles.
To make sure is a ssas connection problem we have created 3 tests situation.
first one, we create a Power Bi with a embed dummy database (no datasource connection) with a mesure contain a now() value. When we pined this mesure, the refresh work.
second, we create a Power Bi with a sql database connection with a mesure contain a now() value. When we pined this mesure, the refresh work.
The last one, we create a Power Bi with a SSAS connection with a mesure contain a now() value. When we pined this mesure, the refresh work doesn't work.
Please note, the tests never use data from database just the created mesure contain now().
we thought is a gateway problem but the pined lives pages work and the manually also.
We found this documentation :
Tile refresh
Power BI maintains a cache for every tile visual on your dashboards and proactively updates the tile caches when data changes. In other words, tile refresh happens automatically following a data refresh. This is true for both, scheduled and on-demand refresh operations.
But this fact doesn't work for us with a SSAS connection.
Some suggestions ?
2 Replies
- v-yalanwu-msft
Community Support
Hi, Anonymous ;
This is because pin a live report as tile does not refresh with the dataset, it refreshed when the report refresh, and you need to manual refresh the report to bring the changes to the Dashboard live report tile.
According to official document: “Pin the tile to an existing dashboard or to a new dashboard. Notice the highlighted text: Pin live page enables changes to reports to appear in the dashboard tile when the page is refreshed.”For you requirement, you can pin the visuals to the dashboard separately, then they will refresh after each schedule refresh on the dataset.
or you could use a chrome extension called Super Auto Refresh to refresh the browser automatically at 1 or 2 minute intervals. (on wallboards in the office) .
https://www.reddit.com/r/PowerBI/comments/b5q66s/the_tiles_are_not_refreshing_please_help/
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - AnonymousNot applicable
Thank you for the reply,
But my problem is when you say :For you requirement, you can pin the visuals to the dashboard separately, then they will refresh after each schedule refresh on the dataset. My tiles doesn't refresh on schedule refresh when my connection is base on SSAS. I just want to know, how to fix this.
On this thread : Dashboard Tiles not refreshing with SSAS Back End - Microsoft Power BI Community
The person have post this message 5 years a go and seem have the same problem.
maybe the problem has been resolved since....