Connection error to SharePoint Online List

[erock12]

Getting an error when connecting from PBI Desktop to SharePoint Online list using out of the box Online Service for SPO.

All other lists on this site connect with no issue.  Obviously points to some field or data in a field that PBI doesn't like.  Went through removing every field mothodically one at a time and error remains. 

SOLVED: turns out removing the Count function from the Totals section of the SPO view fixed it!  

[Anonymous]

Hi, @erock12 

It looks like you solved the problem you were having.

Could you please share your solution and accept it as solution?  It will be helpful for other members of the community who have similar problems as yours to solve it faster.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @erock12 - Please check the below solved thread FYR:

https://community.powerbi.com/t5/Desktop/DataSource-Error-Web-Contents-failed-to-get-data-from-500/m...

https://community.powerbi.com/t5/Desktop/DataSource-Error-Web-Contents-failed-to-get-contents-from-a...

https://community.powerbi.com/t5/Power-Query/DataSource-Error-Web-Contents-failed-to-get-contents-fr...

Hope it helps to fix.