Forum Discussion

BStof's avatar
BStof
New Member
2 years ago

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

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

Dataflow
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.