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 🙂