Forum Discussion

Drane21's avatar
Drane21
Copper Contributor
May 16, 2026

Data from a web page - error is "Access to the resource is forbidden."

Details: "Access to the resource is forbidden.", can anyone let me know how to resolve this error

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Try this in order—one of these almost always works:

    1. Clear old permissions first
      Go to Data → Get Data → Data Source Settings → Clear Permissions for that URL, then try again.
    2. Bypass Copilot and use Power Query directly
      Go to Data → From Web, paste the URL. If the site blocks bots, open the Advanced Editor and add a User-Agent header so the request looks like a browser:

    = Web.Contents("your-url", [Headers=[#"User-Agent"="Mozilla/5.0"]])

    1. If all else fails and you understand the risk
      In Power Query, go to Data Source Settings → Privacy → "Ignore Privacy Levels", then retry.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.