Forum Discussion
Query folding indicator on a Sharepoint online source is not folding
Hi folks, Hi Anonymous and @v-yingjl
I am using a SharePoint Online list as a source to Power Query online in a Datamart. The documentation of query folding (QF) mentions that SPO list is supported by QF. But in reality, the QF indicator on the Source in Power Query Online is negative : the evaluation is done outside the source. The Query Plan do not mention "Remote" as for SQL Datasources as well.
SharePoint list does not fold in Power Query OnLine
Can you still confirm the indicator is not correct as to SharePoint Online list ?
Here is my M query :
let
Source = SharePoint.Tables("https://mytenant.sharepoint.com/sites/e-formation", [Implementation = "2.0", ViewMode = "All"]),
Navigation = Source{[Id = "88793cdf-6a25-4341-a714-d2fed50456b5"]}[Items],
#"Lignes filtrées" = Table.SelectRows(Navigation, each ([Proprétaire] = "Jean Dujardin"))
in
#"Lignes filtrées"
1 Reply
bump. I would also like to know answer to OP's question.
