Value from Excel cell directly to Power Query

This tutorial explains how to get value from a cell in sheet into a Power Query. Obviously, it only works in Excel – not in Power BI.

Power Query can´t take value from a cell using reference like “C2”, but it can work with an inserted table. This table can only have one row, containing the cell we need.

So to get the value of cell we can simply write this code into first step of query:

• = Excel.CurrentWorkbook(){[Name=”nice_table“]}[Content][nice_column]{0}

Just replace the red text with your names of table and column.

This value can be used in any other query, not only in a Custom column:

Typically, this can be used to dynamically define the path to source file or folder.