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 works with the path generated by the Embed option).

However, this method doesn't work anymore as Onedrive changed something and the path generated is not the same, thus Power Query cannot identify the generated and altered path.

Any idea how to work with the new generated path?

 

Regards,

Ayal Telem.

excel

4 Replies

  • AyalT1575's avatar
    AyalT1575
    Copper Contributor
    Sep 18, 2025

    As of 9/2025 previous solutions doesn't work.

    Extensive correspondence with OneDrive support didn't do any good, and they referred me to Office support, which after admiting that OneDrive changes broke many things including reading to PQ, said that it's out of scope for support they give.

    Can anyone help with this?

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Apr 06, 2025

    Consider below:

     

    1. 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.
    2. 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.
    3. 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.
    • 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