Forum Discussion

J-ML's avatar
J-ML
Regular Visitor
5 years ago

connection error to Sharepoint List

I've the following error when I try to refresh data from a connection to a Sharepoint list. I've also this issue when I try to create a new fresh connection to it: Expression.Error: The columns para...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi J-ML ,

 

This means that the server returned an error. There may be an error message in the body of the HTTP response; if so, you can use a tool like Fiddler to trace your HTTP traffic and see what the message is.

 

Perhaps it is best to start a new query, and select Sharepoint Folder with the above URL. Better to clear and re-fill data source settings, or start from a new blank file.

 

Refer to:

https://community.powerbi.com/t5/Desktop/Unable-to-access-to-SharePoint-Folder-with-Files/td-p/871113

https://www.poweredsolutions.co/2019/04/04/connecting-to-files-in-sharepoint-onedrive-with-power-bi-power-query/

https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/m-p/237546

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.