- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

To manage a large amount of data you could flow these guidelines:
- Remove all unused columns from your data table.
- You used a slicer in the report so that I could consider you could maintain fact and dimension tables in the data model.
- 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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-16-2023 07:44 PM | |||
05-28-2024 12:45 PM | |||
02-29-2024 09:49 PM | |||
06-06-2024 01:37 AM | |||
04-04-2023 02:38 AM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |