Automatic Incremental refresh issue

[Anonymous]

Hi, 

Since we switch to 2021, the automatic incremental do something really weird, when i do a manual refresh of Power Bi Desktop, everything going well and I can publish it to my Power Bi service but when I launch an incremental refresh on Service, it's working but at the end the data of january are deleted and my data stop to 30/12/2020. I've already checked my range start/end, all my incremental parameters and nothing seems to explain why this behavior for the automatic incremental refresh. 

Everything is on Sharepoint with CSV or XLS.

Thank you for your help. 

[GilbertQ]

Hi @Anonymous 

I think you need to ensure you only have got CSV and XLSX files and not any XLS files. I know that XLS files will not refresh via the Power BI Service.

[Anonymous]

oh really, i didn't know this.
I checked it and all my datafiles are CSV or XLSX

[GilbertQ]

Hi @Anonymous 

What happens when you re-upload the PBIX and then configure the dataset data source.

And then refresh it twice?

The first time creates the partitions, the second time should then only do the incremental refresh.

Also how exactly have you configured your incremental refresh policy?

[Anonymous]

Hi,

obsviously, I tried this, and I tried with a new file too and the result is the same on Power Bi Service.

This is my incremental configuration.

[GilbertQ]

Hi @Anonymous 

What is the range in your incremental configuration that you have set?

Also can you confirm that the CSV and XLS (This should be XLSX files) have the most recent data.

NOTE: If you have XLS files you will have an issue with it refreshing via the Power BI Service.

[Anonymous]

Hi Gilbert, 

Yes the files have most recent data, as said, when I do a manual refresh from power BI desktop, everything going well and I've all the data.

I've CSV, XLS and XLSX

The range start ist 01/01/2018
The range end is 01/01/2022

Thanks for helping