User experience during dataset refresh?

[tshaffery]

I'm receiving some help desk issues from users who are seeing incorrect or blank data in their reports during a dataset refresh. I've tried recreating this issue in a test environment with no luck. The dataset takes about 15 minutes to refresh and the issues are coming in around that time. I've been told that Microsoft caches data and this shouldn't be happening. Is this true? What could cause the data anomolies and what's the best way to mitigate it?

[v-jialluo-msft]

^{Hi @tshaffery ,}

^{It is recommended that you clear the report and page-level filters before refreshing, or you can try to republish the dataset to resolve it, If configured correctly, the append query will have no errors.}

^{Best Regards,}

^{Gallen Luo}

[v-jialluo-msft]

^{Hi @tshaffery ,}

^{Do users have this questions with all datasets? Whether it can be displayed normally after the refresh is completed}

^{It may be because the dataset has an append query causing a refresh error}

^{Please refer to the following link:}

Solved: Blank Reports on Refresh - Microsoft Power BI Community

^{If this is not the answer you need, please describe the question further}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[tshaffery]

The report displays correctly once the refresh is completed. The suggested link appears to be an issue even after the refresh is completed so I don't think it's the appended queries, unless you're saying the append function causes an issue during the refresh as well? I haven't seen issues reported with other datasets, but those datasets refresh considerably faster and aren't used as frequently.

Can you confirm that the user should not be experiencing blank values during a dataset refresh and that an append function could cause this during a refresh?