Forum Discussion
Solved
5000 threshold sharepoint connection - PBI
i would like to overcome a (500): Internal Server Error related to 5000 threshold from sharepoint. I have a PBI connected to sharepoint list using "sharepoint online list" connector. After the lis...
Hi jps_HHH
To what the others are recommending, if there is a date column that is used for your data, you could then apply incremental refresh to this particular table, which potentially then would only refresh the new data and not go past the 5000 limit because you're doing it on a daily basis. So each day we'll have our own separate query.
In my example M,
Filtered = Table.SelectRows(List, each [Created] >= #date(2024,1,1))
[Created] is the indexed column. By filtering before any other transformation, SharePoint only returns the rows within that range.
But I cannnot connect the sahrepoint list to PBI. the error happens in the second step of the powerquerry, i dont have chance to filter the data that I want to retrive from sharepoint