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.
we had the same behavior on one of our lists, that had 20k items long time woking an suddenly did not work anymore.
We found, that there was an aggregation (count) set in the default view of the list. So even, if you use the "all" setting, which should ignore all view settings, the aggregation setting of the default view seems to result in an error.
So for us, removing the aggregation from the default view of the list, solved this issue.
Hi, can you help me with this "removing the aggregation from the default view of the list" - how could I do it?
Thanks!
hi Ola_G,
in the SharePoint list, in the upper right of the list, select the default view and then click on edit current view.if there is an aggregation for any of the columns, set it to "none". This was fixing the problem for us.
Don't forget to save these changes
Saved me, thanks... I also seemed to have to remove the grouping from the list as well! Thanks
Hi Anonymous
many thanks, it worked for me as well- it was enough to remove the grouping from the default view.
It works for me, after a few month with this issue!
Thanks!
