What is the maximum limit for number of rows in a particular table through push dataset?

[cte_crest]

Hello every one,

I am new to powerBI and I am also trying to design a solution in which I want to push the data to the PowerBI service's workspace dataset through the PowerBI apis using service principal. I am trying to use the DatasetMode as Push (Not Streaming). 

I can also find that there are two options for DefaultRetentionPolicy: None and basicFIFO.

As per https://docs.microsoft.com/en-us/power-bi/developer/automation/api-rest-api-limitations, if my retention policy is None, then I can have maximum 5,000,000 rows in a single table. Q1: What happens if I add more rows? Is there any provision to increase the capacity? Also, if the retention policy is basicFIFO, then the older records will be removed and newer ones will replace them. Q2: So, can I use this retention policy with the push dataset (not streaming)?  

 

[GilbertQ · Accepted solution]

Hi there

Q1: Currently you cannot increase the limit and as far as I know in the past it would stop refreshing data when it hit the limit.

Q2: unfortunately this will not work with changing the push dataset.

[cte_crest]

Thanks @GilbertQ for the clarification. 

I also did a POC on this. The API starts throwing something like "Table Full" Exception, after the row reaches 5 Million.

Also, FIFO approach works for the push dataset as well, in which we'll have around 200,000 rows at a time in a particular table.