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.

GeraldGEmerick's avatar
GeraldGEmerick
Icon for Memorable Member rankMemorable Member
1 year ago

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? 

  • stb628's avatar
    stb628
    New Member
    1 year ago

    Thanks GeraldGEmerick.  Worth a try, but the errors also occur when accessing local json files (no URL).

    • GeraldGEmerick's avatar
      GeraldGEmerick
      Icon for Memorable Member rankMemorable Member
      1 year ago

      stb628 That's really strange. Something must have gone wrong with that Windows update I guess?