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

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 TDNoz,

         i too facing same issue, how can we understand this data..Can anyone pls help..