Defined Name use in Power Query

[qwewer]

Good day,

I named a cell to "XYZ" and use it in Power Query as

Excel.CurrentWorkbook(){[Name="XYZ"]}[Content]{0}[Column1]

The question is, - if possible - how can I use a Defined Name in Power Query if it isn't refered to a range/cell but have an exact value?

Thanks in advance!

 

[RoryA]

You can't (currently, at least). You'd have to put the value in a cell.