Forum Discussion

Ghislain's avatar
Ghislain
Advocate I
9 years ago
Solved

PowerBI support for OneDrive Personal as data source

Hi everyone !   I'm trying to get data in my powerBI desktop from an excel file which in OneDrive personal but I can't Copy/Paste the link of my file. Can we upload from OneDrive personal ?   Tha...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Ghislain,

    Yes. Please use the following link  to connect to excel file located at OneDrive for personal from Power BI Desktop.

    https://onedrive.live.com/download?resid=AAXXXX&authkey=AAXXXXXXX&em=x&app=Excel

    Replace the bold parts with the resid and authkey that are found by right-clicking on the specific file and selecting “Embed”.



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Ghislain,

Yes. Please use the following link  to connect to excel file located at OneDrive for personal from Power BI Desktop.

https://onedrive.live.com/download?resid=AAXXXX&authkey=AAXXXXXXX&em=x&app=Excel

Replace the bold parts with the resid and authkey that are found by right-clicking on the specific file and selecting “Embed”.



Thanks,
Lydia Zhang

  • bihumano's avatar
    bihumano
    Helper I
    1 year ago

    This procedure is not working anymore. 
    Onedrive changed the url from embed code, removing the resid  &authkey

    Is there any workaround?

    Seems that Google drive is easier to share a xlsx to power bi than onedrive!

    • timbckr's avatar
      timbckr
      New Member
      1 year ago

      Hi i got the same issue,

      have you found a solution?

       

      Thank you!

      • bihumano's avatar
        bihumano
        Helper I
        1 year ago

        I had to buy a onedrive business to use XLS with the powerbi web. 

        one drive personal won't work anymore.

    • balthasar's avatar
      balthasar
      New Member
      8 months ago

      Have you found any solution? 

  • Ghislain's avatar
    Ghislain
    Advocate I
    9 years ago

    Thank   @v-yuezhe-msft  for your answer ! It works perfectly !!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      hi, I did that way and it seems it could connect to my excel file in onedrive personal however, 

      it does not recognize tables... first my excel's table wasn't "table" format so I made them as "Table" format

      however, still the same, Power BI does not read data.

       

      After connecting, navigator screen shows only..  folder-document.

      The document's table view on the right side shows.. only...

      Kind        Name  Children   text

      Element  HTML   table        null

       

      how can I have it read data?

       

       

       

       

       

      • Vassilium's avatar
        Vassilium
        Frequent Visitor
        8 years ago
        I am trying to connect a file from my personal drive based on the above and seems that three is an issue with the credentials which does no permit the Power Bi service to update and get data from the OneDrive personal

        From some posts I realized that there some changes on the authentication
        As we speak I cannot connect to excel file when I don’t have any issue with CVS files
        Is there any update?
        Can anyone enlighten us?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, 

    This doesn't work with me..........i could copy the URL & paste it in power bi (Web Source), but while loading i couldnot find the appropriate columns. After loading i could find data like this..........how can i get appropriate data. please provide steps if possible

     

    thanx in advance..

  • joopiest's avatar
    joopiest
    Frequent Visitor
    7 years ago

    Thank you very much. Very helpful

  • omid020's avatar
    omid020
    New Member
    2 years ago

    After digging Google for two days I found this solution works like a charm!

    Thank you!