Forum Discussion

Heena_9980400's avatar
Heena_9980400
Icon for Helper IV rankHelper IV
4 years ago

Need Help on dealing historical data in Power Bi

Hi Experts,   I am working on a project where I am dealing with 10 years of historical data(there is no live data) and the reports are ad-hoc reports we are not using any measures or logic(just kee...
data protection
Need Help
Show and Tell
Tips and Tricks
Royel's avatar
Royel
Icon for Super User rankSuper User
4 years ago

To manage a large amount of data you could flow these guidelines:

 

  1. Remove all unused columns from your data table.
  2. You used a slicer in the report so that I could consider you could maintain fact and dimension tables in the data model.  
  3. If possible, summarize your data. For Example, If you did some calculations in the visual like summation, count and so on do it in the backend (Power Query or SQL Query or anywhere) it will reduce lots of records and make your report lighter and faster.

 

If you think this idea will help you to manage your large dataset.

Then please accept the answer.