Forum Discussion
Solved
History Data Analysis option in Streaming dataset
Dear Team, We ahve option in streaming dataset to enable history data analysis. what is the max size of this dataset, is it same as for the limit of other datasets , that is 1 GB? Br, Sh...
Hi shamsuddeenvp,
Not like other dataset, when Historic data analysis is enabled, the dataset created becomes both a streaming dataset and a push dataset.
For a streaming dataset, there is no underlying database, Power BI only stores the data into a temporary cache, which quickly expires.
For a push dataset there are following limitations on how much data can be pushed in:
- 75 max columns
- 75 max tables
- 200,000 max rows stored per table in FIFO dataset
- 5,000,000 max rows stored per table in ‘none retention policy’ dataset
For more details, you can refer to the following articles. :smileyhappy:
Real-time streaming in Power BI
Regards
According to v-ljerr-msft answer..
Using the easily UI, which is the default policy used when creating a new streaming dataset?
If FIFO Dataset is not the answer to my question, how can i change to this value?