cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kkalyanthaya Regular Visitor
Regular Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
2 REPLIES 2
Community Support Team
Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
zoloturu
Advisor

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

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