excel power query to coworker's shared excel file on onedrive - access forbidden error

Copper Contributor

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?

0 Replies