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?