Forum Discussion
Data Refresh - What do end users see during the process?
Thanks Seth.
So, I assume cached copies take into consideration the report level filters that are being used?
We ended up manually refreshing our data and noticed that reports we had hit prior to the refresh rendered and those that we hit during the refresh (as a different user, which meant different report filters) did not.
It seems that a better approach here would be for PBI to refresh into a temporary table and then swap that with the live table (or tables) once the refresh is complete. I understand there's overhead involved here but there'd certainly be less impact to the end user with this approach.
tmcdevitt They will see the cached dataset until the new data replaces it. If they are actively looking at the report, and the refresh occured and finished while they were still looking they would need to refresh their browser to see the new data.
Thanks Seth.
So, I assume cached copies take into consideration the report level filters that are being used?
We ended up manually refreshing our data and noticed that reports we had hit prior to the refresh rendered and those that we hit during the refresh (as a different user, which meant different report filters) did not.
It seems that a better approach here would be for PBI to refresh into a temporary table and then swap that with the live table (or tables) once the refresh is complete. I understand there's overhead involved here but there'd certainly be less impact to the end user with this approach.