Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

DaFloDo's avatar
DaFloDo
Resolver I
7 months ago

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.

 

NunoMota's avatar
NunoMota
New Member
7 months ago

Good point DaFloDo, I wasn't aware of that! I checked and there is none. I don't think I ever used that to be honest. But thank you for the suggestion.

Updating the query from:

= SharePoint.Tables("https://site", [Implementation="2.0", ViewMode="All"])

to:
= SharePoint.Tables("https://site", [ApiVersion = 15])

 

Seems to have worked though! However, the others with 50k+ items are not configured like this... Very strange!