Power BI Rest Api Limitations

[remeez]

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

[Anonymous]

You can only use Python script cant run curl command  powershell or c# from PowerBI .

In some case where you need to make mulitipule calls for Rest API and refresh token etc this limitation can play Significant role.

Thanks

[v-micsh-msft]

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}/rows

Reference

Regards,

Michael

[remeez]

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.

[ross_lambert]

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 ==