cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tchoffatWB
Frequent Visitor

Automatic Incremental refresh issue

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. 

6 REPLIES 6
GilbertQ
Super User II
Super User II

Hi @tchoffatWB 

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

Hi @tchoffatWB 


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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.

tchoffatWB_1-1611301991550.png

 

GilbertQ
Super User II
Super User II

Hi @tchoffatWB 

 

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors