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.
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
It works for me, after a few month with this issue!
Thanks!