Forum Discussion
Error Connecting to SharePoint List (500): Internal Server Error
With no changes made to the source SharePoint list my report refresh started failing this morning with the error below. I've had this happen on a different list and never found a fix for it. E...
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.
NunoMota did you check for aggregates on a column (count, sum, ....) in the SharePoint default view? this could be the reason for this error. If so, just remove the aggregate.
Thank you! Thank you! Thank you!
I never once thought the aggregates would have anything to do with it. This solved my issue 🙂