Notifications
Clear all
Power Query
2
Posts
1
Users
1
Reactions
262
Views
Topic starter
Hi,
This video (Power Query connect to OneDrive Personal files | Excel Off The Grid), which shows how to get a file from Onedrive to PQ was working wonderfully and I used it few time.
Not anymore.
Recently (I heard 2 months ago) the path generated by Onedrive->Embed option has changed, and cannot be recognized by PQ anymore.
does anybody nows how to get the correct path?
Regards,
Ayal Telem.
Posted : 06/04/2025 7:54 pm
Topic starter
And the solution, courtesy of Mynda:
- In Onedrive, right-click the file and go to "</>Embed".
- At the bottom of the popup, click the "Customise how this embeded workbook will appear to others"
- In the new browser's tab appear, look for the "Embed Code" section, where you will find the path you need.
- After copying the path, use this video "Get data from OneDrive Personal files with Power Query" to manipulate the path to a path PQ can digest.
Thank Mynda.
Posted : 08/04/2025 9:11 pm
Anders Sehlstedt reacted