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

403 “forbidden” is the website rejecting the request, not Excel itself. Try these in order:

1. Clear saved credentials: Data → Get Data → Data Source Settings, find the URL, Edit/Clear Permissions, then refresh and re-enter.

2. Try a different auth kind when prompted — Anonymous for public sites, Basic/Web API/Organizational for protected ones.

3. Open the URL in a browser. If it loads there but not in Power Query, the site is blocking non-browser requests (Cloudflare, bot filtering, etc.) and there’s no workaround from Excel — you’d need an API.

4. Check for a login wall. Power Query can’t handle interactive sign-ins.

If you share the URL, we can tell you which one it is.