Streaming - Which is the RetencionPolicy value when HistoricDataAnalysis is disabled/enabled?

[rbobadilla]

Hi guys, reading about Streaming Data in Power BI, I realize that there are two possible values for the parameter defaultRetencionPolicy:

• none: 5,000,000 max rows stored per table
• basicFIFO: data will collect in a table until it hits 200,000 rows. Once the data goes beyond 200,000 rows, the oldest rows will get dropped from the dataset

So here, all great, but anyway, this parameter can only be setted programatticaly using the Power BI Rest API.

In my case, I don't want to use this option and code an aplication, instead it, i want to use the UI provided from Power BI. And here is my question: i didn't find any information about the defaultretencionpolicy parameter when using the Streaming Dataset UI.

I just know that, using this option, enabling Historic Data Analysis is equivalent to using the Power BI REST APIs to create a dataset with its defaultMode set to pushStreaming. According to the official documentation, data is temporally stored in a cache.

Does it means that, in this case, the defaultretencionpolicy value is basicFIFO, and if i enable the Historic Data Analysis option, the defaultretencionpolicy is setted to "none" ?

Look forward to your comments.

Regards!

[GilbertQ]

Hi @rbobadilla

You can set this via the UI when you create your streaming data set, as shown below?

Which you can get to under Dataset if you have already created a streaming dataset.

[rbobadilla]

Thank your for your repply @GilbertQ.

I can set that value, yes. So, does it mean that if i enable the Historic Data Analysis Option, i am setting a "none" policy restriction, whereas if i set the option as off, i am setting a "basicFIFO" policy restriction?

[GilbertQ]

Yes your description is 100% correct.