Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Incremental refresh folding

Hello everyone, 

 

I want to apply incremental refresh. I have set up the parameters RangeStart and RangeEnd, and used these parameters as filters for the table I want to use for incremental refresh. Unfortunately, I have the following message:

 

IncrementalRefreshDesktopnoconfirmation.png

 

I already deleted all the steps in Query Editor: 

IncrementalRefreshQueryEditor.png

Or is it the source which prevents the incremental refresh? 

 

Secondly, the parameters are not recognized in the Online Service: 

IncrementalRefreshOnlineService.png

 

I assume this is correlated with each other, and if one issue is solved, the other issue is solved as well. That's why I included both questions as one. 

 

Finally, the parameters look like this:

IncrementalRefreshParameters.png

 

 

3 REPLIES 3
Gabry
Super User
Super User

Hello,

What datasource are you using?

 

You can look at this discussion https://community.fabric.microsoft.com/t5/Desktop/Unable-to-M-query-can-be-folded-incremental-refres...

Anonymous
Not applicable

I am using Exact online, a software package. But I think that it's not possible to use this data source. As you can see, the source is ConnectorExactOnline.Imports("1", 3). That '3' means that you load 3 years of data. So, it doesn't make sense to apply incremental refresh with this data source. 

You can still use incremental refresh, using rangestart and rangeend parameters in your M code.

Google, incremental refresh api call

It's a workaround but still you might do the job

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.