Unable to Refresh

[DavidRPitts]

What does it mean when your query shows complete but you hang at the Apply Query Changes (This one was for 8 Hours still had to cancel)

[v-lili6-msft]

hi  @DavidRPitts 

I think it should be stuck.

Please cancel it and then try these:

1. Upgrade power bi desktop to the latest version

2. Open Power BI --->File--->Options and Settings--->Options--->Data Load---> Uncheck autodetect new relationships after data is loaded

3. Clear PBI Desktop cache
4. Refresh all queries in preview
5. Clean cache then refresh all in preview

6. Disable privacy check for the report

Reference article:

https://blog.crossjoin.co.uk/2017/05/24/data-privacy-settings-in-power-bipower-query-part-1-performa...

Regards,

Lin