Power BI REST API limitations
Published: November 1, 2015
Updated: October 17, 2016
The Power BI REST API has the following 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
POST Rows operation per Power BI plan
Dataset created by user with free service plan: 10,000 rows added per hour per dataset
Dataset created by user with paid service plan: 1,000,000 rows added per hour per dataset
If a user exceeds this limit, we will fail subsequent API calls with the following details:
- HTTP Status Code: 429 Too Many Requests
- Response header: Retry-After + {Number of seconds until their quota resets}
- An OData error with the following message: "You are over your rows per hour limit for this dataset. To push more rows per hour, upgrade your account to Power BI Pro or retry your push later."
Show: