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:
thank you for sharing!
I received this error when I originally was using the '.aspx' link from my team's sharepoint.
As the directions in the blog post above suggest, after I trimmed down the end, it worked.
https://COMPANYWEBSITE.sharepoint.com/teams/QUALITY/Quality%20Assurance/SitePages/Home
Helper IIAll,
I was able to find a solution on my end.
Problem: I was combining both Azure and Excel/SharePoint as datasources for a single report and I realized I could not schedule refreshes once published to the services site. When attempting to edit credentials from the services site, i did not have the ability to make adjustments and select organizational accounts. After investigating, i determined that my problem was associated to my excel data connector and not having the credentials to pull the data while off premise.
Solution: I changed the excel data connector to SharePoint Online Folder and I pointed the connector to the primary URL path for the Teams Site. For example (https://xxx.sharepoint.com/sites/xxx/xxxTeamWorkspac) is what I used and I removed the remaining extension. Once I executed the connector, i was able to gain connectivity, i had exposure to all of the objects/files located on the teams site and it was simply a matter of navigating to my xls files and pulling it in. Once published, i now had the ability to edit the credentials for the dataset, enagle to organizational credentials so that users with the right permissions can access the content.
Hope this helps