Query Folding

[Anonymous]

Do xml files have the capability of query folding?
I'm using data source as xml and have traced every step in query editor to check whether it has "view native query" enabled or not and it was greyed out in all steps.

[mahoneypat]

While your source hosting your XML files may not allow folding, you can still benefit from incremental refresh. Do your XML files have the date in the name? or is there a created/modified date? If in the name, you can parse it out and create a DateTime column, and do incremental refresh on that.

How you can incrementally refresh any Power BI data source (This example is a CSV File) - FourMoo | ...

Pat

[Anonymous]

is there any other similar way of doing incremental refresh which would npt be based on query folding other than scheduled refresh?

[AlexisOlson]

XML is essentially a flat file. It's not like connecting to an engine that will support folding or incremental refresh (it's just a file; there's no engine at all). If you want your data to be able to do these things, you'll need to store it somewhere that does have a query engine (like a database or a SharePoint list).

[Vijay_A_Verma]

No. 

"Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not."

https://docs.microsoft.com/en-us/power-query/power-query-folding