Power BI REST API Limitation on Non-Retention-Policy data set

[kkalyanthaya]

Hi,

I have been using Power BI REST APIs for posting rows to dataset. In FIFO i see that 2,00,000 is MAX rows a table can hold. Beyond that it is a FIFO model.

For Non-Retention-Policy dataset documentation says 5,000,000 is the MAX rows. What is the behavoiur of the dataset beyond this limit ? If this is not FIFO will my POSt call just fail ?

Thanks,

Kiran

[zoloturu]

Hi @kkalyanthaya,

Can you close not needed internet applications for little time, then run Fiddler and then run your POST request and track all events once done. There you will see how step by step how much rows were transferred and status of it.

* I recommend saving Fiddler trace to the file for further use (in case you will open a ticket to Microsoft).

Regards,

Ruslan

[v-shex-msft · Accepted solution]

Hi @kkalyanthaya,

It should return error code to notice records amount has exceed to limit.
BTW, FIFO mode is for live steam dataset, otherwise it means the ‘non retention policy’ dataset..

Reference link:

Common REST API Error Codes

Power BI REST API limitations

Regards,

Xiaoxin Sheng