Forum Discussion

shamsuddeenvp's avatar
shamsuddeenvp
Post Patron
9 years ago
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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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:

    Power BI REST API limitations

    Real-time streaming in Power BI

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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:

Power BI REST API limitations

Real-time streaming in Power BI

 

Regards