Forum Discussion
Error Connecting to SharePoint List (500): Internal Server Error
Nope, opened a ticket with Micorosft Premier support and they said it's a SharePoint issue. SharePoint support said nothing can be done. a lot of wasted time.
.
I thought the point of using the Power BI 2.0 connection to SharePoint was to leverage paging and avoid issues like this.
Hi Anonymous ,
If you have multiple queries and when refreshing, Power BI evaluate and refresh all queries at the same time.
This may be the cause of this error.
Please try turning off the parallel data loading in the options for data load.
That will then not load the data in parallel but rather one at a time.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cleared cache(s)
Updated the setting you mentioned
Createad a new report
Source:
SharePoint Online List
2.0 option
Selected the list
Same error noted above.
The 2.0 Implementation must be used due to the size of the SharePoint list.
Hello, im with the same error.
I noticed that the error started after the sharepoint list had more than 5k items.
did u find any solution to this error?
in my case i need to switch conection too 1.0 and rebuild the views.No, there is no fix.
If you scroll up you will see my response.