Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello guys!
Could you help me connecting to a spreadsheet in SharePoint Online?
Here are the steps I'm following:
1 - Get data from web
2 - Paste the URL as follows:
3 - I got the below error:
"Unable to connect: We encountered an error while trying to connect. Details: URL is invalid."
- In the first time trying to connect, it was asked to start the session with SharePoint, and it was ok;
- I have access to Sharepoint, both published site and spreadsheet
- If I try to open this URL in a new tab in Browser, it opens normally
- I tried to remove "&action=default" from URL, but I got the same problem
- I also tried to connect using bothlinks "to view" and "to edit", provided by SharePoint when you click "..." at the right side of the the file
What I'm doing wrong?
Thanks!
Solved! Go to Solution.
I just faced the exact same problem. Solved it by getting the link to the Excel file on Sharepoint (right click -> get a link). You then need to manipulate the link a bit:
From:
To:
https://abcdef.sharepoint.com/sites/.../Shared Documents/Miscellaneous/
Then get data -> Excel -> past the link above -> select the file.
/Sune
I can't connect as you explained, in the folder, then get data -> Excel.
BUT after sucessive attempts, it worked changing the link as you described, like we are used to do in Windows Explorer, and the filename in the end, like that:
https://XXXXX.sharepoint.com/sites/XXXXX/Documentos Compartilhados/Book Gestão/File.xls
Thanks @sfibaek !
I just faced the exact same problem. Solved it by getting the link to the Excel file on Sharepoint (right click -> get a link). You then need to manipulate the link a bit:
From:
To:
https://abcdef.sharepoint.com/sites/.../Shared Documents/Miscellaneous/
Then get data -> Excel -> past the link above -> select the file.
/Sune
I can't connect as you explained, in the folder, then get data -> Excel.
BUT after sucessive attempts, it worked changing the link as you described, like we are used to do in Windows Explorer, and the filename in the end, like that:
https://XXXXX.sharepoint.com/sites/XXXXX/Documentos Compartilhados/Book Gestão/File.xls
Thanks @sfibaek !