Dec 11 2020 07:30 AM
Hi
Goal: use excel power query to load data from an excel file that a coworker has shared from their onedrive
Problem statement: excel power query unable to connect "Access to the resource is forbidden" error
I have tried to connect using get data from file and using the file path
https://myworkplace-my.sharepoint.com/personal/username/Documents/
to get to the folder where the file is and I can see it and select the file
I have also tried to connect using from web and have the same issue
How can I connect to this file?