Forum Discussion
Getting Query Folding to work with a SharePoint Online List
Hi,
I've recently started connecting to SharePoint Online Lists using Power Query and am hoping to get query folding working.
When I look under 'Sources that support folding' in Microsoft's query folding documentation, I can see that it mentions that SharePoint lists can be folded:
However in my testing I cannot seem to get it to work. Has anyone had any luck, or knows of any other documentation about query folding for a SharePoint Online list?
Added info:
- I'm using SharePoint Online
- I've tried connecting using all of the standard SharePoint connectors as well as OData methods described here and here.
- To check whether query folding is working I've been placing a single column filter on the table I get from the list and right clicking to see if 'View Native Query' is available as described here.
(note: there's another post on this question, but it's quite old, so thought I'd create a new one in the hope that someone has an answer)
Hi Anonymous ,
As far as I know, web sources like SharePoint Online etc. could not use 'View Native Query' to check whether the folding happens directly.
The data source that can view native query must be folded, and the data source that can’t view native query is not necessarily not folded.
Share Point Online sends some ODATA requests essentially that you can try to use Fiddler to catch the requests when you connect it directly and use ODATA to connect with the same operations like remove columns which features support query folding to compare whether the requests are the same.
Query folding means that every time all the data will be taken to Power BI for processing, so the request sent out is to take all the data
For folding, such as deleting some columns, then you can observe that the request sent by Power BI only contains those columns that I need.
Hopes it could help.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Please see this video. It doesn't leverage folding, but it much faster.
Get SharePoint List Data with Power BI ... Fast - YouTube
Pat
Hi Anonymous ,
As far as I know, web sources like SharePoint Online etc. could not use 'View Native Query' to check whether the folding happens directly.
The data source that can view native query must be folded, and the data source that can’t view native query is not necessarily not folded.
Share Point Online sends some ODATA requests essentially that you can try to use Fiddler to catch the requests when you connect it directly and use ODATA to connect with the same operations like remove columns which features support query folding to compare whether the requests are the same.
Query folding means that every time all the data will be taken to Power BI for processing, so the request sent out is to take all the data
For folding, such as deleting some columns, then you can observe that the request sent by Power BI only contains those columns that I need.
Hopes it could help.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
