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 trying to connect:

The file definately exists, please could you point me in the right direction? 🙂

 

Thank you for your help,

 

CM

Need Help

14 Replies

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

    Hi Anonymous ,

     

    What is this $value in the file path?

     

     

    Thanks,

    Pragati

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Pragati11 

       

      I don't know, this is what I entered (i.e. ending in .xlsx). I don't think I've entered $value anywhere.

      (Also I don't think I can check what is in the mcode because it's before that stage in the wizard)

       

       

       

    • 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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Did you try to delete ‘/$Value’ in the advanced editor?

    This is my connection query and I import the excel file from OneDrive for Business successfully.

    let
    Source = Excel.Workbook(Web.Contents("https://qiuyunus-my.sharepoint.com/personal/xxxx/Documents/FileName.xlsx"), null, true),
    Sales_Sheet = Source{[Item="Sales",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sales_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Product", type text}, {"Sales", Int64.Type}, {"Region", type text}})
in
    #"Changed Type"

     

    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.

     

  • 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 🙂