Archived data is not archiving, the report is just showing the incremental data

[mpinedaporras]

Hi everyone, I'm trying to set up the Incremental refresh. All the settings apparently are fine, I followed all the steps on the power query side. But at the time of the refresh on the PBI service, is not archiving the 2 years that I set on the configuration, is just showing the 2 months data of incremental.

Any ideas or thoughts?

[mariussve1 · Accepted solution]

Hi,

In the fact table you want incremental refresh on you had to set a RangeStart and RangEnd filter, could you please share the M Code for the table, or at least the filter Code?

And to be sure, you need to deploy the model to the service before the archive 2years Will be applied. In desktop it will only show the RangeStart - RangeEnd filtreres period.

Br

Marius

[GilbertQ · Accepted solution]

Hi @mpinedaporras 

Further to what @mariussve1 Also make sure that you have refreshed your semantic model in the power BI service. It only. loads the historical data in once the refresh as completed.

[v-tsaipranay · Accepted solution]

Hi @mpinedaporras ,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you've set up incremental refresh, but you're encountering an issue where only the incremental (recent) data is being shown, and not the full historical data (2 years) as expected.

Based on your details you provided, it seems like the issue might be related to a couple of things that need to be double-checked which as alredy been mentioned by @mariussve1 and @GilbertQ  and thankyou for your inputs.

Please let me know if you require any further assistance. Feel free to reach out.

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

Thank you.

[v-tsaipranay]

Hi @mpinedaporras ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-tsaipranay]

Hi @mpinedaporras ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[GilbertQ · Accepted solution]

Hi @mpinedaporras 

Further to what @mariussve1 Also make sure that you have refreshed your semantic model in the power BI service. It only. loads the historical data in once the refresh as completed.

[mariussve1 · Accepted solution]

Hi,

In the fact table you want incremental refresh on you had to set a RangeStart and RangEnd filter, could you please share the M Code for the table, or at least the filter Code?

And to be sure, you need to deploy the model to the service before the archive 2years Will be applied. In desktop it will only show the RangeStart - RangeEnd filtreres period.

Br

Marius