Forum Discussion

sshweky's avatar
sshweky
Helper III
10 years ago
Solved

relative file reference

Hi - I am trying to pull data from a dropbox file in Power Query. However, every user has a different path to that dropbox file. Any ideas on how to use dynamic file references in the advanced query ...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Hm, strange.

    Please try another split on _invdtl 

     

    Otherwise please try if the other option works (just to check if there isn't anything else to it here, or a bug)

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

sshweky You can use newly introduced parameters functionality to dynamically switch data sources. 

  • sshweky's avatar
    sshweky
    Helper III
    10 years ago

    Do you have an example or soemthing I can read? I am not familiar with this?

    • sshweky's avatar
      sshweky
      Helper III
      10 years ago

      I am working in Excel 2016 with Power Query (not PowerBI). Here is a little bit more detail of the way I am doing it ...

       

      So far I have an excel file with a table called "MyPath" which stores each user's path. The value in my "MyPath" is "C:\Users\Steven\Desktop\Dropbox". How do I retrieve that path, combine it with the file name "\dashboard\fc.mdb" and use that entire file name to build a query in my main template file?

       

      I tried to build a query (called PathQuery) to retrieve the path from "MyPath.xlsx" & then combine the path & the file name, but I get an error that I can't combine a Type List with a Type Text.

       

      lpath= PathQuery[MyPath],
      lfile = Text.Combine({lpath, "\FC\dashboard\fc.mdb"}, ""),
      Source = Access.Database(lfile),

       

      Thank so much for your help!!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        So many questions on Power Query and M... so many things to learn. In the meantime, it's nice to know people like ImkeF. Maybe she can help out with this.