Append Query Failing to Refresh

[Nadim1]

Hi all,

Seems I'm having a recent issue (as of today, it appears) where my query appends aren't seeming to refresh / load in Power BI (it just hangs and won't load). I read through a couple other related threads, and it seems the issue comes from Privacy Level Errors (all my privacy levels are set to Organizational for reference). Seems one of them got reset to "None" - I changed it back, although issue didn't resolve itself. Selecting Ignore Privacy Levels seemed to do the trick, which leads me to believe that this is the crux of the issue. 

This is odd though as it worked perfectly fine prior to today, so not sure why all of a sudden this gives me headache. A similar append in Power Query in Excel works perfectly fine, however. Anyone know why this might be and how to go about fixing this? 

[v-stephen-msft]

Hi @Nadim1 ,

Please check if there are any updates or changes to the data source that may have caused the issue.

Or you could also try creating a new report using this data source to see if this issue exists.

Best Regards,

Stephen Tao

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