Store Historical Data Without Refreshing

[Anonymous]

Is it possible to Store Historical Data Without Refreshing  ?

I have 2 data queries. One of them stores historical data, the 2 queries appending on Power Query side and i'm just using this third appended query.

I don't want to refresh historical query , is it possible with enable load option. Actually i wasn't sure about this.

[v-xicai · Accepted solution]

Hi @Anonymous ,

If the database is very large, you may use Incremental refresh for your data source, the Incremental refreshes only data that has changed.

Since incremental refresh is Premium only feature, so you may need to purchase Power BI Premium capacity for your organization, see How to purchase Power BI Premium.

Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service. See more detail steps: Incremental refresh in Power BI Premium .

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.