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

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