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 ,

 

The video from RADACAD is very straight forward.

 

You are getting Not Found error, that means Power BI cannot find this file to your one-drive location.

 

Is your One Drive and Power BI credentials point to same account?

Login to your one drive, navigate to the path that you are trying to access in PBI and check whether your file exists there or not?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pragati11 yes onedrive and power bi use the same account.

 

Yes if I go to onedrive I can see the file. If I enter the file url into the browser the excel file opens.

    • 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

    • jkadilak's avatar
      jkadilak
      Icon for Advocate I rankAdvocate I
      4 years ago

      This was very helpful for me - solved the problem. Thanks!