Power BI Error

[bnelly1987]

I am trying to run a large workflow to create a Power BI file. The output is roughly 700 MB which is under the 1 GB threshold that Power BI allows. I am getting an error that says "Power BI API error... HTTP/1.1 429{"error":{code":"You are over your rows per hour limit for this dataset. Please retry your request later.""

Does anybody know what the rows per hour limit is? Does anyone know a workaround to get past this?

[JessieC · Accepted solution]

@bnelly1987 - https://docs.microsoft.com/en-us/power-bi/developer/api-rest-api-limitations

To POST Rows

• 75 max columns
• 75 max tables
• 10,000 max rows per single POST rows request
• 1,000,000 rows added per hour per dataset
• 5 max pending POST rows requests per dataset
• 120 POST rows requests per minute per dataset
• If table has 250,000 or more rows, 120 POST rows requests per hour per dataset
• 200,000 max rows stored per table in FIFO dataset
• 5,000,000 max rows stored per table in ‘none retention policy’ dataset
• 4,000 characters per value for string column in POST rows operation

[Ychurc]

Could you please explain what POST mean in "10,000 max rows per single POST rows request"? Thanks!

[briangeneration]

Following - getting similar error and unsure the language in that response. Can I only post 10,000 rows in an output? That seems awfully low.