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.

Ola_G's avatar
Ola_G
Frequent Visitor
3 years ago

Hi, can you help me with this "removing the aggregation from the default view of the list" - how could I do it?

Thanks!

DaFloDo's avatar
DaFloDo
Icon for Resolver I rankResolver I
3 years ago

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