Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all
I have an excel file with one tab stored in a box. I need to get the data from the URL of that box that contains the excel file.
When I do the get data from the Web option I get the following:
The steps I follow are then:
As seen, the table that contains the columns of the excel never appears.
How can I make the table appear using the link? The reason I need to use the link and not get it straight from the folder excel route is because I need other people to refresh the query.
Using the excel route would not work since it would be created with my user, therefore I would be the only one able to make updates.
I tried the same with one drive and didnt work either, here is a sample.
https://1drv.ms/x/s!ApgeWwGTKtFdhmBSr7ewHPMnY08Y?e=9Uz3gS
Thanks all.
Solved! Go to Solution.
Hi @o59393 ,
Pls refer to below link:
https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
https://community.powerbi.com/t5/Power-Query/box-com/td-p/119392
Hi @o59393 ,
Pls refer to below link:
https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
https://community.powerbi.com/t5/Power-Query/box-com/td-p/119392
Please refer to this link https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Thanks for the help, do you know how to make it work with Box?
The links dont contain the web part at the end.
Thanks!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |