Forum Discussion

stb628's avatar
stb628
New Member
1 year ago
Solved

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 w...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    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.

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

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

  1. Right click the app or script and choose Run as administrator to bypass new restrictions.

  2. Right click the .Json file- Properties. If you see an Unblock checkbox, tick it and click Apply.

  3. Create a new local admin user and try your queries there. This can help rule out profile specific permission issues.

Regards,
Yugandhar.