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

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.