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)
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 cache4. Refresh all queries in preview5. Clean cache then refresh all in preview
6. Disable privacy check for the report