Failure to load data in dashboard - error: Web.Contents failed to get contents from {URL} (429): 429

[BStof]

Hi,

I have an existing model and dashboard that have so far worked well. Today I successfully loaded new data in the Power Query/Data Editor. However, when trying to apply the queries on this new data, I repeatedly get the following error for different queries after a long loading time, preventing the loading of the new data in the dashboard:

"Web.Contents failed to get contents from {URL} (429): 429"

I have tried to look for similar issues in this community and solutions that were offered in those, but didn't find anything that I could try out. 

It would be great to get your support. 

Many thanks,

Bram

[v-jianpeng-msft]

Hi, @BStof 

The 429 error code indicates that you are currently having too many web requests. You should reduce the number of your requests, so you should re-edit your M code to reduce the number of requests to ensure that the data can be requested within 120 seconds. Web.Contents supports a minimum wait time of 0.5 seconds and a maximum of 120 seconds

Handling status codes with Web.Contents for Power Query connectors - Power Query | Microsoft Learn

What you can do at the moment is limit the number of requests you have mentioned earlier or manually specify the behavior under this error, you can refer to the following documentation:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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