Connection error to SharePoint Online List

Question

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!

rajendraongole1 · Answer

Hi&nbsp;erock12&nbsp;- Please check the below solved thread FYR:
&nbsp;
https://community.powerbi.com/t5/Desktop/DataSource-Error-Web-Contents-failed-to-get-data-from-500/m-p/392703
https://community.powerbi.com/t5/Desktop/DataSource-Error-Web-Contents-failed-to-get-contents-from-app/m-p/2417545
https://community.powerbi.com/t5/Power-Query/DataSource-Error-Web-Contents-failed-to-get-contents-from-URL/m-p/2181574
&nbsp;
Hope it helps to fix.

anonymous · Answer

Hi,&nbsp;erock12&nbsp;
It looks like you solved the problem you were having.
&nbsp;
Could you please share your solution and accept it as solution?&nbsp; It will be helpful for other members of the community who have similar problems as yours to solve it faster.
&nbsp;
&nbsp;
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.

Forum Discussion

Connection error to SharePoint Online List

2 Replies

Related content

OData Error When Connecting to SharePoint Online

Sharepoint online and Reporting server

Establishing Cloud Connection w/ SharePoint Online

Sharepoint Connection

Connecting to sharepoint