Forum Discussion
Advocate IIDashboards 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!
Any update on this issue?
Due to the lack of dashboard refresh, subscriptions are basically useless.
Solved! - Sort of....
After much deliberation with MS tech support, the problem was narrowed down to the date filter slider I was using.
Anonymousis correct. When a tile on the dash is created from a filtered result set, the tile does not change when the result set is updated. It still thinks it is within a specific date range.
For example, if my results were narrowed down with a date slider to be between 01/01/17 and 9/20/17 and I created the dash tile on 9/20; on 9/21 the results would be the same as the day before. The tile retained the filtered date range I set previously, ignoring the new info.
Sadly, it sort of makes sense. The way around it is to use "views". If you pin the tile as a view on your dash, the results pushed to the dash will be confined to the parameters set in the report. I personally set my query to pull a result set for the whole year allowing me a moving YTD date range to work with. As the date filter is only set on the "left" side (the beginning time) I leave the end time open to whatever the last result is. That way, my reports refresh which in turn keeps my pinned views on my dashboard accurate.
I hope this makes sense. It took me a while to get my head wrapped around it to be honest. Too many dates.
Good luck!!