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.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
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.