Forum Discussion
Connecting to a SharePoint List Office 365 error
Hi John
When trying to connect to the list are you using the full URL of the list, or just linking to the site URL?
i had a similar problem which was caused by trying to link to the full list address.
See thread:
Hey everyone, my colleague had initially linked to the direct sharepoint file link. It was working fine, til only recently (after 1 year), the error came up.
I realized he had used to connect directly to the sharepoint excel file link:
'Source'
=Excel.Workbook(Web.Contents("https://xxx.sharepoint.com/sites/xxx/Shared%20Documents/General/xxx%20Dashboard%20Power%20BI/xxx.xlsx"), null, true)
Strangely once I tried to log in to my credentials and tried to troubleshoot and relink the website, it works. Hence, it seems that linking to the sharepoint file weblink directly using Web.Contents works?
Appreciate if anyone knows if this is the correct method, or linking via sharepoint folder would be better.
Thank you!