Forum Discussion
Power BI Rest Api Limitations
Hi,
The Power BI REST API has the following limitations, are these limitations per group/workspace? We are build a multi tenant solution with a workspace for each client.
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
Regards
Remeez
4 Replies
The Limits is for the whole Power BI Embeded API, there is no restriction/limits on the Group/workspace when Post rows..
The post action for the Add Row API is as below:
POST https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{table_name}/rowsRegards,
Michael
Thanks v-micsh-msft for your response.
Sorry, what I am trying to undestand is, what happens if I have more than 75 tables? Is the 75 table limit per POST request?
If I have more than one client, with 100 tables each, and these are being updated every night.
I would also like to understand what happens if you hit the 5,000,000 row limit. Does it then age-out the oldest rows (FIFO)? If so, how is that different than basicFIFO?
Thanks,
== Ross ==
