Forum Discussion

WaelTalaat79's avatar
WaelTalaat79
Helper I
3 years ago
Solved

Data Enable folding for huge 5 years data

Dears, I prepared a 5 years data and i need to enable the incremental refresh but i got an message as below "Unable to confirm if the M query can be folded. it is not recommended to use incrementa...
Need Help
WaelTalaat79's avatar
WaelTalaat79
Helper I
3 years ago

Dear,
thanks for your reply, 
the data sourcing is an CSV + Excel file reading from sharepoint & onedrive
and when i checked the sequence data report steps the enable folding is desapled from "Source" step

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi WaelTalaat79 ,

//the data sourcing is an CSV + Excel file reading from sharepoint & onedrive.
The reason is here. They are both flat data sources and they do not support query folding. Consider importing this data into a data source that supports query folding before reconfiguring incremental refresh.

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data