Forum Discussion

AyalT1575's avatar
AyalT1575
Copper Contributor
Apr 05, 2025

OneDrive Personal file path to Power Query

Hi, To get a file from Onedrive Personal to Power Query there was a method that used to work, and I used it few times successfully (video here: https://www.youtube.com/watch?v=RsL77ddhXoYbasically w...
excel
AyalT1575's avatar
AyalT1575
Copper Contributor
Apr 06, 2025

Hi Kidd_Ip,

The embed option will not work anymore since it's issuing a path Excel PQ cannot work with, even with trying to manipulate it.

File Path never worked correctly.

 

Regards,

Ayal Telem.

 

AyalT1575's avatar
AyalT1575
Copper Contributor
Apr 08, 2025

And the solution, courtesy of Mynda Treacy of https://www.myonlinetraininghub.com/:

  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 "https://exceloffthegrid.com/power-query-connect-to-onedrive-personal-files/" to manipulate the path to a path PQ can digest.

Codus Mynda.

Resources