Forum Discussion
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...
Consider below:
- Using the Embed Option: You can still generate an embed code for your file in OneDrive, but you'll need to modify the URL manually. After generating the embed code, replace the word "embed" in the URL with "download." This should create a downloadable link that Power Query can recognize.
- Copying the File Path: If the file is open in Excel, you can copy its path directly. Navigate to File > Info and click the "Copy Path" button. Ensure that the URL ends with ?web=1 and remove those characters before using it in Power Query.
- Web Connector in Power Query: Use the "From Web" option in Power Query to paste the modified URL. This method often works for connecting to files stored in OneDrive Personal.
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.
And the solution, courtesy of Mynda Treacy of https://www.myonlinetraininghub.com/:
- 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 "https://exceloffthegrid.com/power-query-connect-to-onedrive-personal-files/" to manipulate the path to a path PQ can digest.
Codus Mynda.
