What step needs to be taken to deal with huge data

[Heena_9980400]

Hi Experts,

I created reports on 10 years of historical data, each report has 25 to 30 million of data and its one load and second load will be done in the next 6 months. So my doubt is which mode is better and is 1 schedule refresh required?

I have a pro license with Premium workspace capacity> how this will help me dealing huge data

Warm Regards,

H

[GilbertQ · Accepted solution]

Hi @Heena_9980400 

What you can do is to use Incremental refreshing. Using Incremental refreshing means it will only re-load the last few days of data.

When you also configure the incremental settings you can set it to have 10 years of history. When the dataset loads for the first time, it will then query and get the last 10 years of data into your Premium workspace.

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn