Read cell from power query

Hello

Rather than using this code in PQ at the beginning of the each query

let
Path = Excel.CurrentWorkbook(){[Name="PPath"]}[Content]{0}[Column1],

How can I store that cell value into PQ and call it from all queries? rather than add it to all queries

you can use named range instead of table
this is a very simple example where you can use query Value in every other queries

HTH

Update:
This will work and I can call "PPath" from all queries to get the dynamic URL
but I have to edit the privacy settings in all PC that will use the file

let
    Source = Excel.CurrentWorkbook(){[Name="PPath"]}[Content],
    Column1 = Source{0}[Column1]
in
    Column1

is that any way to do it better that changing the settings?

as I said you can use named range instead of the table, read posts carefully

you only need to change privacy settings once or ask PQ manufacturers

This VBA in workbook open, will ignore privacy level for all queries and solve the problem
Thanks

ThisWorkbook.Queries.FastCombine = True

Originally Posted by Undo

This VBA

Your choice

Will it cause problems for me?

I don't know, I just hate VBA, that's all