topic PowerBI support for OneDrive Personal as data source in Power Query

PowerBI support for OneDrive Personal as data source

Ghislain — Fri, 17 Feb 2017 14:11:04 GMT

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 ?

Thank's in advance

Re: PowerBI support for OneDrive Personal as data source

Anonymous — Mon, 27 Feb 2017 05:46:47 GMT

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

Re: PowerBI support for OneDrive Personal as data source

Ghislain — Thu, 23 Feb 2017 13:46:27 GMT

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

Re: PowerBI support for OneDrive Personal as data source

tadam98 — Wed, 19 Apr 2017 15:45:57 GMT

When I follow this procedure in PowerBI Desktop and do Home/NewQuery/Web and place the URL instead of linking to the excel, it calls up excel and opens it in exel.

EMBED CODE from EXCEL:

INSERTED INTO THE PROPOSED TEMPLATE:

https://onedrive.live.com/download?resid=46E7F41E91D28B46%21568&authkey=AGH0iThHc_3Xq9k&em=2&app=Excel

The generated m_language code is:

let
Source = Excel.Workbook(Web.Contents("https://onedrive.live.com/download?resid=46E7F41E91D28B46%21568&authkey=AGH0iThHc_3Xq9k&em=2&app=Excel"), null, true),
Q2_2015_Table = Source{[Item="Q2_2015",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Q2_2015_Table,{{"Month", type date}, {"Category", type text}, {"Product", type text}, {"Sales", type number}}),
#"Removed Blank Rows" = Table.SelectRows(#"Changed Type", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
#"Removed Blank Rows"

In your code, make sure Q2_2015 and Q2_2015_Table are substituted with the name of a table you want to access. In case the table is NOT found PowerBI desktop will ask you to select a table.

Note the added step of Removed Blank Rows - apparently when reading excel dara placed on a web drive some blank rows might be added. So this step gets rid of those.

Code was competed and tested with http://www.myonlinetraininghub.com/ which taught me what I know.

Mickey

Re: PowerBI support for OneDrive Personal as data source

Anonymous — Mon, 11 Sep 2017 20:12:19 GMT

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?

Re: PowerBI support for OneDrive Personal as data source

Vassilium — Tue, 07 Aug 2018 14:03:35 GMT

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?

Re: PowerBI support for OneDrive Personal as data source

Anonymous — Tue, 12 Feb 2019 06:55:22 GMT

Hi TDNoz,

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

Re: PowerBI support for OneDrive Personal as data source

Anonymous — Tue, 12 Feb 2019 07:04:20 GMT

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

Re: PowerBI support for OneDrive Personal as data source

joopiest — Thu, 18 Apr 2019 13:52:24 GMT

Thank you very much. Very helpful

Re: PowerBI support for OneDrive Personal as data source

omid020 — Thu, 22 Feb 2024 23:24:13 GMT

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

Thank you!

Re: PowerBI support for OneDrive Personal as data source

bihumano — Tue, 04 Mar 2025 21:46:07 GMT

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!

Re: PowerBI support for OneDrive Personal as data source

timbckr — Thu, 27 Mar 2025 11:54:05 GMT

Hi i got the same issue,

have you found a solution?

Thank you!

Re: PowerBI support for OneDrive Personal as data source

bihumano — Thu, 27 Mar 2025 12:04:18 GMT

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

one drive personal won't work anymore.

Re: PowerBI support for OneDrive Personal as data source

sgenc — Sat, 12 Apr 2025 09:00:28 GMT

It seems that Microsoft pushes customers to use Business products instead of OneDrive personal without giving any information.

Re: PowerBI support for OneDrive Personal as data source

balthasar — Thu, 11 Dec 2025 09:27:43 GMT

Have you found any solution?