Forum Discussion

Magnus Vegem Dahle's avatar
Magnus Vegem Dahle
Brass Contributor
Jun 20, 2018
Solved

Power Query Source from Relative Paths

Hi All,

 

I am making an analysis tool that uses two Excel file sources via Power Query. The tool work well, but as soon as the file and source files are moved to another location it stops working as the Queries sources from aboslute paths.

 

Can I modify my Sourcing so that as long as the Analysis tool file and the source files are in the same folder the Query will find and use the correct files? So that the Query sources from a path relative to the Analysis Tool file.

 

Thanks!

Magnus

27 Replies

No RepliesBe the first to reply

Resources