Historical data analysis

[kmas]

Hi all,

I have created two streaming datasets, they are exactly from the same source, however, one has the 'Historical Data Analysis' option enabled, whilst the other one has this option disabled.

I want to create two different reports (each of them associated to one of the above streaming datasets), however, I can't create a report using the dataset with the 'Historical Data Analysis' disabled. Basically, Power BI doesn't allow me to select that dataset (only the dataset with this option enabled appears in the corresponding PBI window). 

Can someone explain this issue to me? Which are the differences between both streaming datasets? 

Thanks in advance

[v-juanli-msft · Accepted solution]

Hi @kmas

For the streaming dataset which has the 'Historical Data Analysis'  option disabled, Power BI only stores the data into a temporary cache, which quickly expires.

There is no underlying database, so you cannot build report visuals using the data that flows in from the stream. As such, you cannot make use of report functionality such as filtering, custom visuals, and other report functions.

When Historic data analysis is enabled, the dataset created becomes both a streaming dataset and a push dataset.

With a push dataset, data is pushed into the Power BI service. When the dataset is created, the Power BI service automatically creates a new database in the service to store the data. Since there is an underlying database that continues to store the data as it comes in, reports can be created with the data. 

Refrence
Real-time streaming in Power BI

Best Regards

Maggie

[kmas]

Thanks Maggie!