Forum Discussion
Dashboards are not refreshing
Hi googlogmob, Are you still see this issue? If so, can you file a support ticket at https://support.powerbi.com/ since may require more in depth troubleshooting. Thanks!
This feature is restricting us to automate out dashboards. we always have to create new dashboard whenever there is new set of data available. consider the scenario where one has to publish daily reports and he/she has to make dashboard each and everytime which is very annoying. Atleast in excel we just have to refresh pivot/charts and view gets changed accordingly
Ok. So, my latest "workaround" from Microsoft works however, it is a good news / bad news situation...
From Microsoft:
The RC is a date time filter on the report page from the date slicer (bottom left visual). It appears that the customer has the below ordering of events.
- Report has date slicer from 1/1/2017 to 7/31/17.
- Customer pins tile, which saves a filter for that date range (as shown by traces)
- The date range is changed on the report (to end at 7/1) and saved.
- The report now is filtering to a different date range than the tile. We do not update tiles if the report is changed, the user must re-pin the tile. In this case the report has a different date range than the visual.
This explains why there would be different date range in the tile vs the report.
My recommendation to the customer is to:
- Delete the tile
- In the report, clear the date slicer state. You can do this by dragging the left slider all the way to the left, and the right slider all the way to the right (set the min/max) on the date slicer visual. By setting the min/max you are setting "no filter"
- Save the report
- Pin the visual - the visual will have no date filtering.
- Refresh - visual should match report before and after refresh
The good news... This works. The bad news is it basically negates the date slicer function from the dashboards. Reports can still be filtered manually however, the most important fingertip info cannot be? For shame.
I have replied back to the support staff stating this very issue and hope to hear from the soon. Mind you, this issue has been going on for MONTHS. Meanwhile, I rebuild dashboards... wait for it ... DAILY.
Hi mate,
It's a shame that dashboards with filters don't refresh and it's been going for months. Consider using views if your data is on a SQL database.
Hope this helps.
Cheers,
Anton
When we pin any tile to dashboard it creates a copy on the dashboard, it is not linked with report anymore. It is linked directly to the dataset. This is what I learnt from usage. I use dashboard to highlight just summaries, pin only those tiles you are not expecting to change for long time and use those tiles as navigation to the actual report. Do not place too much information on the dashboard.
Isn't the whole point of dashboards to show small snippets of automatically refreshed information?
