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,
Just following up to see if the Response provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar