Forum Discussion

remeez's avatar
remeez
Frequent Visitor
8 years ago

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 m...
Need Help
v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
8 years ago

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's avatar
remeez
Frequent Visitor
8 years ago

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's avatar
    ross_lambert
    Regular Visitor
    8 years ago

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