Forum Discussion
Filtering pinned tiles
Hi Anonymous ,
The dashboard tile refreshes happen about every hour so that the tiles show recent results. You can change the schedule in the dataset settings, or force a dashboard update manually by selecting the ellipsis (...) in the upper right of a dashboard and selecting Refresh dashboard tiles.
The Scheduled cache refresh section of the Datasets tab is not available for datasets in import mode. These datasets don't require a separate tile refresh because Power BI refreshes the tiles automatically during each scheduled or on-demand data refresh.
Because it happens automatically, you can consider tile refresh an intrinsic part of data refresh. Among other things, you might notice that the refresh duration increases with the number of tiles. The tile refresh overhead can be significant.
By default, Power BI maintains a single cache for every tile, but if you use dynamic security to restrict data access based on user roles, as covered in the article row-level security (RLS) with Power BI, then Power BI must maintain a cache for every role and every tile. The number of tile caches multiplies by the number of roles.
You can learn more:Data refresh in Power BI, Troubleshooting tile errors.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous7 years agoNot applicable
I think my description wasn't clear, but the issue is the state of any filters or slicers do not update in the tiles.
My primary page has a bar chart with is a 12-month rolling average (12MRA). Once per month I update the filters/slicers so that the forst and last months advance by one month.
This never filters through to the pinned live tiles. The state remains as it was when I first pinned it, so that (for example) the report current runs July `18 through June `19, but the pinned page is still stuck at May `18 through April `19, and I see no way to update the range on the pinned tiles without deleting the entre dashboard and recreating it (since it uses the New filter experience, and not on-page slicers.
- Anonymous6 years agoNot applicable
I hate to necro this post, but even after figuring out my error (that was preventing me from pinning tiles) I still have the same issue.
A brief summary of my problem: I have a series of reports, each with a high-level MAAR chart that is a rolling 12-month average. Later pages have much more detail, but it's the overview 12MRA charts that senior management likes to see "at a glance," and that I've all pinned (as live tiles) to the main dashboard. The data itself auto-updates every 24 hours, so no issues there, but at the start of every month I move the start and end dates (on every report MAAR chart) forward by one month, to keep the 12-month rollling average continuous and ending on the last day of the previous full month.
This all works fine and dandy on the reports themselves, but the pinned tiles NEVER update, leaving me to delete te entire dashboard and re-pin tiles (which clearly aren't "live") every month also - a royal PITA.
I am guessing MS never thought of this and there is no solution??