CansuT's avatar
CansuT
Regular Visitor
1 year ago
Status:
Investigating

Incremental Refresh giving Expression.Error: There weren't enough elements in the enumeration to com

Hi, I have 3 folders that I am importing from sharepoint into power query. Each of these folders include multiple csv files from different periods, so either a file per year or quarter. I am cons...
Dashboards
Data Modeling
Reports
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi  CansuT ,

 

Please make sure that the indentation in your Power Query M code is correct. Improper indentation can cause unexpected errors. and double-check the filtering steps that use RangeStart and RangeEnd to ensure they are correctly filtering the data. The columns used in the filter exist and must have the correct data types.

None of the tables return empty results after applying the incremental refresh filter. Even if the tables return rows when you manually check the filter, there might be cases where the filter results in an empty table during the actual refresh.

If it does not help, try add debugging steps to your code to print out in termediate results and column names. This can help you pinpoint where the issue is occurring.

 

Best regards.
Community Support Team_Caitlyn

 

 

Completed Ideas