Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
(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)
Solved! Go to Solution.
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.
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.
Please see this video. It doesn't leverage folding, but it much faster.
Get SharePoint List Data with Power BI ... Fast - YouTube
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat,
Thanks for that, but I was really looking for query folding.
It's not so much the speed of the query that I'm looking for, but more the ability to have the server pick up the load for some subsequent transformations.