Forum Discussion
Query Folding in Excel 2016 connected to Dynamics CRM 2016 On-Premises
When I connect Excel 2016 Power Query to a CRM On Premise 2016 system using the OData Feed and OData 4.0 or 2.0 connection URL, how can I make sure that QueryFolding takes place? I read some arti...
v-sihou-msft
Microsoft Employee
Microsoft Employee
If a SQL Query can't run against the source, the View Native Query function will not be available. In this scenario, you may get Metadata in Power Query. Please refer to Chris Webb's blog:
Another Way To Check Query Folding In Power BI/Power Query M Code
Regards,
Thank you Simon_Hou-MSFT for your answer!
I have tried that out what is described by Chris Webb's Blog:
Added into the advanced editor
GetMetadata = Value.Metadata(#"Filtered Rows"),
QueryFolding = GetMetadata[QueryFolding]and replaced
#"Filtered Rows"
with the last step of my query.
However I'm always getting IsFolded: False, even with the most simple steps applied like select columns or rows.
Is Query Folding not applied for CRM On Premise? Or is it simply not detectable here?