This short tutorial describes the Power Query (Get and Transform) connection to a file, whose name and path is written in a specific cell. This can be used when you needs to simply control, which file is used as source, without even opening Power Query.

First of all add a table with one column and one row and type filepath to its only cell. The name of table is going to be, lets say, "Table1" and the name of its only column is going to be "Column1".

The query taking data from this file (from Sheet1) looks like this (in Power Query advanced editor):

Just replace the names of table and column by your ones...

If you need relative path instead of the absolute one, click here.

1 Comment

Leave a Reply

Your email address will not be published.

*

clear formPost comment