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.
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.