sharepoint view

Thank you, Greg_Deckler. It seems the threshold is not imposed by administratior. Rather it's a hard limit on SP lists that are not indexed.

But after my post, I think I have found a way to work around it, which could also be the solution for the original question of this thread gbritton. It turns out Power BI can also connect to SP list through "Web" under "Other" in Get Data. The steps are as below:

1. Go to the view of a SP list, export it and save the iqy file, instead of opening it straight away.

2. Open the iqy file with Notepad and copy the URL address, which includes names of list and view.

3. Get Data in Power BI by choosing Web.

4. Paste the URL link in the field and choose the right table

5. Repeat the steps above for other views and join all the tables together to get the whole data.