Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 keeping data in a table visual with 1 filter) and how power bi will handle that huge amount of data, is there any tricks to deal with it, kindly help me on this and do the needful.
BR,
Kousar
To manage a large amount of data you could flow these guidelines:
If you think this idea will help you to manage your large dataset.
Then please accept the answer.
Hi @Heena_9980400 ,
You could start of with the use case.. If the business objective is to identify sales trend for the past 10 years.
Then you could reduce the granularity of your data by having 1 fact table (Sales Data) and multiple dimension tables related to the fact table. (Dimension table depends on the user requirements/ asking the user).
BR
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
100 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |