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
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?

 

 

 

 

 

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