Forum Discussion
Dashboard is not refreshing
Hi,
We have a report designed in PowerBI Deskptop that has a period filter in order the limit YTD comparisons for this year against last year. At the end of each period this filter is updated to reflect the new period and is published, overriding the existing reports. Everything has worked fine as the URL remains the same so links are not broken
I've now looked to build dashboards to reflect this updated data, but when the report is updated the dashboards are not. Why do dashboards on PowerBI have such a fundamental flaw? Is there a workaround?
- Hi there
When you pin a report to a dashboard it pins it with the filter context being applied.
For example if you pinned it for the first time with the Period Filter for Mar 2019, that is how the dashboard tile will work, always keeping the filter for Mar 2019.
If you then change your report to filter for Apr 2019, the existing Dashboard tile will still hold Mar 2019.
What you can do is to rather not hardcode your filter, but potentially use the Date table and a column which will have on the example above a filter name of "Current Month" This will then allow the dashboard tile to filter based on "Current Month" and NOT on a hardcoded month.
1 Reply
- GilbertQ
Super User
Hi there
When you pin a report to a dashboard it pins it with the filter context being applied.
For example if you pinned it for the first time with the Period Filter for Mar 2019, that is how the dashboard tile will work, always keeping the filter for Mar 2019.
If you then change your report to filter for Apr 2019, the existing Dashboard tile will still hold Mar 2019.
What you can do is to rather not hardcode your filter, but potentially use the Date table and a column which will have on the example above a filter name of "Current Month" This will then allow the dashboard tile to filter based on "Current Month" and NOT on a hardcoded month.