Forum Discussion
Filter rows in Sharepoint list
Hi all,
Is there a way to filter the data thats pulled from source (a sharepoint list) by date, i only want the last 6 months, but there is years of history in the list and its cuasing a 429 error.
= Source{[Id="dp67579c-3ea7-4f8c-a501-f8528r3fbb5a"]}[Items]
I currently have (see above) this but i wondered if i could put a date parameter at this stage rather than pulling it all in and then filtering it?
Is this possible?
Really appreciate any tips
1 Reply
Hi the_606,
Much theoretically, Sharepoint list is query-foldable. Which means that there is a chance that your date filter would be passed to the Sharepoint (as ODATA, I guess) and the request would return only filtered lines.
There are few caveats as I could find doing a quick look around on the Internet:
Query Folding with SharePoint Online List? (microsoft.com)
Solved: Getting Query Folding to work with a SharePoint On... - Microsoft Power BI Community
Maybe look further on the Internet for what you would need to do to increase your chances to get it actually folded?
Cheers,
John
