Showing results for 
Search instead for 
Did you mean: 
abrehman Frequent Visitor
Frequent Visitor

Best Practices for Historic Data

Hello Everyone!

What are the best practices to adopt when we have a large amount of data that we need to load onto our dashboard for historic analysis and trend analysis? I need to ensure that my dashboard dont slow down or keeps on reading the data. As of now, i am planning to use composite model in which i will be using "Enable Historic Analysis" for the historical analysis. That would be enough? Should i keep a separate table for historic analysis?

Need your suggestions.  

Community Support Team
Community Support Team

Re: Best Practices for Historic Data

Hi @abrehman ,

"Enable Historic Analysis" will use streaming dataset, with a streaming dataset, data is also pushed into the Power BI service, with an important difference: Power BI only stores the data into a temporary cache, which quickly expires. 

I would suggest you create another dataset for the normal data, then create another report on this dataset, after that we can pin different reports on the same dashboard.

Best Regards,


Helpful resources

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 55 members 1,108 guests
Please welcome our newest community members: