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.
Dear,
My client's excel data is storaged in their Onedrive. They shared the link with me and I would like to connect my pb desktop with this link to refresh data. However, when I tried to connect via "Get data"--"web", the result of the connection is not excel data but: some text file as following:
I tried some method online, for example: open the link in excel desktop, then 'copy path' etc, it just did not work.
Can someone give me a hint of how to do it?
Hi @Sherwinzhu
According to your description, the customer put the excel file on OneDrive, you should ensure the link format is correct. The link you use should directly point to the Excel file. When you get the shared link, make sure it's the link to the actual file and not a web page or folder. If you're using the link provided by the OneDrive share feature, you might need to adjust it to point directly to the file.
you can refer to the following documents:
Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello everyone!
Sadly I have the same problem.
I use OneDrive for personal files, nothing related to work. But I use Excel online for my financial control (with shared excel files from my family), with connection of Power BI.
It used to have a functional link as a web source via PowerQuery that was something like:
"Excel.Workbook(Web.Contents("https://onedrive.live.com/download?resid=XXXXXXXXXXX%XXXXXXXXX&authkey=%XXXXXXXXXXXXXXXX&em=2&app=Ex...") ".
I believe it is the same problem that @Sherwinzhu is facing, because recently all links on Excel Online in onedrive changed to something like this:
The solution presented by @v-jialongy-msft is, sadly, outdated. ☹️
Looking forward for a solution as well... Because I am getting desperate 😅.
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 |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |