Forum Discussion
5000 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.
Hello jps_HHH
You may want to refer to this post
In summary from this post, the workaround would be either create an Indexed Column in SharePoint, then filter on that column in Power BI queries, which lets SharePoint use the index and avoid the threshold,
Or, apply Filters at Source, which forces SharePoint to only return rows within the indexed range, like
Filtered = Table.SelectRows(List, each [Created] >= #date(2024,1,1))
Hope this helps:)
I 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
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