Forum Discussion
Web.Contents error : Access to the resource is forbidden
I'm trying to connect to a public open data web site for the PA governmental datasets.
One web page is https://www.italiadomani.gov.it/content/sogei-ng/it/it/catalogo-open-data/gare-del-pnrr.html
The page is accessible via browser without any permission requirement (anonymous access) and from the page some files can be freely downloaded, for instance the Json file at link
https://www.italiadomani.gov.it/content/dam/sogei-ng/open_data_2024/PNRR_Gare-Dati_Validati_v3.json
However when I try to connect to the file with PQ module of PowerBI, I get the following error:
"Expression.Error: Access to the resource is forbidden"
This happens for all files that I tried to download from this site.
Can anyone help me understand how to solve the issue?
Many thanks
Hi Anonymous ,
I've done some testing and found that there may be a setting on the site itself that prevents you from connecting to the site directly via the Web connection method or an M code such as Web.Contents to access the content therein.
I'm trying to connect directly to the Home page of the site using the Web Connector directly:But still the same error:
If you can't even connect to the Home page, chances are that the site has disabled certain connectivity features.
If you need Power Query to connect to some of these files, you may need to download the file from the site first, and then use File.Contents to connect to the file you downloaded locally:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
looks like that website is using a specific httpmanager script to prevent automated access. Investigate if they offer an API instead.
Hi Anonymous ,
I've done some testing and found that there may be a setting on the site itself that prevents you from connecting to the site directly via the Web connection method or an M code such as Web.Contents to access the content therein.
I'm trying to connect directly to the Home page of the site using the Web Connector directly:But still the same error:
If you can't even connect to the Home page, chances are that the site has disabled certain connectivity features.
If you need Power Query to connect to some of these files, you may need to download the file from the site first, and then use File.Contents to connect to the file you downloaded locally:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
