Error with Web.Contents

The HTTP 500 Internal Server Error message indicates that the server encountered an unexpected condition that prevented it from fulfilling the request made by the client (your Power BI query).

Unfortunately, there could be many reasons why this error is occurring. It could be a temporary issue with the website, a change in the website's structure that broke your query, or even a security feature implemented by the website to prevent scraping.

If the issue is temporary, you can try refreshing your query again later to see if it resolves itself. If not, you may need to update your query to accommodate any changes made to the website's structure. It is also worth checking with the website's administrator to see if there have been any changes made that could affect your query.

As for the issue with using Web.BrowserContents, it is possible that your organization's firewall is blocking the connection to the website, or that the website is blocking automated requests made by Power BI. If possible, you can try using a personal device with a different internet connection to see if the issue persists. If it does, then it is likely an issue with the website's security measures. In this case, you may need to contact the website administrator to see if they can provide a workaround for accessing their data through automated means.

Best regards, 

Isaac Chavarria 


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly