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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Pragati11  but I'm still getting the same error when I click on OK on the step below (with my url of course). It's not prompting me for credentials.

 

 

  • 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