Power BI Get-PowerBIDatasource Throttling with status code 429

[kim0]

Hello!

I have created an API script that grabs all datasource details for my company's dataset.

It was running under one script and worked perfectly until 02/27/2025.

All of a sudden, I get an error saying "Failed error: status code (429)."

I am using the Get-PowerBIDatasource module (MicrosoftPowerBIMgmt.Data) from Microsoft.

Get-PowerBIDatasource (MicrosoftPowerBIMgmt.Data) | Microsoft Learn

This module doesn't state a request limit on calls, so I'm wondering what the problem (or limit) might be.

I was running about 9000 dataset lists for the datasource, and it was running fine before.

[Deku · Accepted solution]

Please see this similar forum post

[kim0]

Thank you for sharing information for using scanner API!

I was wondering... is there any documentation stating throttling limit for that module?

I was able to run the script just fine until couple days ago.

[Deku]

Not that I've seen on Microsoft docs, but similar Power BI API do have limits

[Deku]

You could throw a sleep in the loop to self throttle yourself to see if that helps

It does state "Each request takes 0.5 seconds to process, during which time other requests are queued" so maybe there is a max queue length?

[kim0]

Thank you for help!

I will try this as well!