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
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Have you removed te highlighted part from the copied URL?

Can you please open a new fresh Power BI Desktop file and try because as I don't have access to your power bi file, I am not sure where things are going wrong as this is a straight forward way to connect to one drive.

Clear Power Bi cache before doing this.

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pragati11 , yes the highlighted part was removed from the copied URL. I've tried from a new power bi file after clearing the cache but it still fails with the same error message unfortunately.

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    5 years ago

    HI Anonymous ,

     

    This is very weird in that case.

    What version of Power BI are you using? Latest April 2021?

     

    Also are you using root folder as highlighted below to acess your one drive file? (I can't see your folder complete location)

     

    I am not able to reproduce this issue at my end as I can successfully connect to One drive from power BI at my end.

     

    I will suggest raising a support ticket here: https://powerbi.microsoft.com/en-us/support/

     

    Thanks,

    Pragati