Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Connecting to OneDrive excel file

Hello,   I'm trying to connect to a onedrive excel file via the "web" data source. I followed these instructions: https://www.youtube.com/watch?v=t4TzHu8THoA   but am getting this error when try...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

Has your problem been solved?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your help, we eventually found the solution 🙂

 

I have 2 onedrives mapped to my computer local drive, and can see all the files on them. They are the 'personal' onedrive of me and a 'power bi admin' account.

 

The file I was trying to access was on the 'power bi admin' account. Even though I could access the file on my computer, in order for power bi to be able to access it via a web link I had to share the relevant folder with myself. And now it works 🙂

 

Thank you for the help 🙂