Forum

From OneDrive Perso...
 
Notifications
Clear all

[Solved] From OneDrive Personal: embed path not working

2 Posts
1 Users
1 Reactions
262 Views
(@j8150outlook-com)
Posts: 53
Trusted Member
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
(@j8150outlook-com)
Posts: 53
Trusted Member
Topic starter
 

And the solution, courtesy of Mynda:

  1. In Onedrive, right-click the file and go to "</>Embed".
  2. At the bottom of the popup, click the "Customise how this embeded workbook will appear to others
  3. In the new browser's tab appear, look for the "Embed Code" section, where you will find the path you need.
  4. 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
Share: