Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
Solved! Go to 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:
Regards,
Xiaoxin Sheng
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
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:
Regards,
Xiaoxin Sheng
| User | Count |
|---|---|
| 16 | |
| 11 | |
| 11 | |
| 8 | |
| 7 |
| User | Count |
|---|---|
| 38 | |
| 34 | |
| 34 | |
| 30 | |
| 20 |