Forum Discussion
Power Query Unexpected Error
Beginning with Windows Update 8/16/25, all of my data queries do not function. They now give splash screen "Unexpected Error" with detail showing 'access denied'. This is true for api requests as well as local json files. Also, Windows refuses to restore backwards before the update (screenshot). Telephone and screen share rep could not resolve. Thank you for any assistance.
Thank you.
STB628
Root Cause: Windows Update (8/16/25) likely changed security settings, blocking Power Query from accessing APIs and local files.
Quick Fixes:
- Run Power BI/Excel as Administrator
- Disable Controlled Folder Access in Windows Defender
- Check file/folder permissions
- Try a Clean Boot to rule out third-party interference
System Restore Blocked: Use DISM /RestoreHealth and sfc /scannow to repair system files.
Want a PowerShell script to check all this in one go? I’ve got you.
8 Replies
stb628 I've seen some other issues cropping up lately regarding similar access denied. Perhaps try adding the URLs into your Trusted Sites in Edge?
Thanks GeraldGEmerick. Worth a try, but the errors also occur when accessing local json files (no URL).
stb628 That's really strange. Something must have gone wrong with that Windows update I guess?
Hi stb628 ,
Thanks for reaching out to the Fabric Community.
The failed System Restore suggests restricted access to protected system directories. A few things you can try
-
Right click the app or script and choose Run as administrator to bypass new restrictions.
-
Right click the .Json file- Properties. If you see an Unblock checkbox, tick it and click Apply.
-
Create a new local admin user and try your queries there. This can help rule out profile specific permission issues.
Regards,
Yugandhar.-
Root Cause: Windows Update (8/16/25) likely changed security settings, blocking Power Query from accessing APIs and local files.
Quick Fixes:
- Run Power BI/Excel as Administrator
- Disable Controlled Folder Access in Windows Defender
- Check file/folder permissions
- Try a Clean Boot to rule out third-party interference
System Restore Blocked: Use DISM /RestoreHealth and sfc /scannow to repair system files.
Want a PowerShell script to check all this in one go? I’ve got you.Hi stb628 ,
Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.Hi stb628 ,
I wanted to check in regarding your issue. Has it been resolved, or do you need any further information. Let me know if you’d like more details.
Thanks.
Hi stb628 ,
Has your issue been resolved, or are you still having any difficulties? If you need more information or help, please let us know.
Thanks
