Forum Discussion

Gary-HL's avatar
Gary-HL
Frequent Visitor
3 years ago
Solved

Incremental Refresh on Sharepoint Excel (table) - Paramaters

Hi All, 

 

I am trying to setup an incremental refresh on a table within a sharepoint excel file. I have parameters RangeStart and RangeEnd setup, yet the incremental refresh setup screen still mentions parameters and options are greyed out. I have referenced these direct in the query to the table (possibly not needed or wrong?). Referenced paramters in filter - "#"Filtered Rows" = Table.SelectRows(#"Changed Type1", each [Date] >= RangeStart and [Date] <= RangeEnd)"

 

Please see screenshots.

 

I have a Pro license.

 

Any ideas why the option to setup the incremental refresh is not working. Thanks.

Any Ideas?