Forum Discussion
Helper II5000 threshold sharepoint connection - PBI
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.
Helper III did not understand the indexed column concept.
However, I've already created a indexec column in the sharepoint. But aftwerads I tried to reconnect with PBI and the same errror occurs.
I dont know what should I do after creating indexed columns.
BTW, I tried to use 1.0 sharepoint online list and it works
Super UserIn 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.
- jps_HHH
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