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.
In addition to what MasonMA mentions, you may consider using the OData connector. I have had better luck with this connector for large lists. Please see the following for others discussing this as well: https://www.reddit.com/r/PowerBI/comments/mra2qj/problem_with_sharepoint_list_connection/
I tried to Odata connector and it says that we couldn't authenticate with the creadiatels provieded (I use my creaditioans in "organiztional account" pane )