Issue Loading more than 200k rows into Power BI

[Simmo2018]

Has anyone else encountered, or more importantly worked around, the limitations of the Power BI API on not being able to load more than 200k rows in an hour via the API? I get these messages trying to run in around 600k of rows into Power BI (using the latest Power BI ouput tool):

Error: Power BI Output (2): Failed to push record(s) to Power BI. 429: Maximum number of requests exceeded in time window. Number of rows in table: 310000. Requests in last 60 minutes: 120. Please retry later.
Error: Power BI Output (2): Failed to push record(s) to Power BI. 429: Maximum number of requests exceeded in time window. Number of rows in table: 310000. Requests in last 60 minutes: 120. Please retry later.
Error: Power BI Output (2): Closing connection to Power BI. Failed to post all rows.

It seems this is standard behaviour from the API (https://docs.microsoft.com/en-us/power-bi/developer/api-rest-api-limitations)

However, 200k isnt large, and I can run in my 600k via PBI desktop and publish but I want to leverage Alteryx to do all my Power BI publishing. Any ideas!?

[ShaanM · Accepted solution]

Hi 

The error you are getting is indicating only certain amount of rows can be pushed into PowerBI in a certain time frame. This is a limitation on PowerBI side.

The way around this is to place a 'Throttle' tool before the PowerBI tool. The 'Throttle' tool can be found in the 'Developer' tool category. This will allow you to throttle and set how many rows to push through.

Kind regards

[Simmo2018]

Hi Shaan,

Throttle will mean the error goes away, but still limits to the 200k rows, I hope Power BI change this limit, 200k rows is not a lot!

Thanks

Matt