Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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
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:
<iframe src="https://onedrive.live.com/embed?cid=46E7F41E91D28B46&resid=46E7F41E91D28B46%21568&authkey=AGH0iThHc_..." width="402" height="346" frameborder="0" scrolling="no"></iframe>
INSERTED INTO THE PROPOSED TEMPLATE:
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=Exc..."), 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
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
After digging Google for two days I found this solution works like a charm!
Thank you!
Thank you very much. Very helpful
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..
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?
Hi TDNoz,
i too facing same issue, how can we understand this data..Can anyone pls help..
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
12 | |
11 | |
11 | |
8 |
User | Count |
---|---|
45 | |
28 | |
14 | |
13 | |
13 |