Forum Discussion
shuhn1229
2 years agoResolver I
Storing and reusing a value as a variable/parameter for other queries
Hi all, Can someone let me know if I am approaching this problem from the right angle? I have an excel sheet that contains a particular value in a specific cell that gets updated somewhat inf...
- Anonymous2 years ago
You can just filter the query for the Excel data to just a list, and then instead of making a proper "parameter" from the GUI, just refer directly to the query as the list parameter. So if the query with your list from Excel is named "FilterList", then your other queries can use it as a parameter like:
let Source = SomeTable
ApplyList = Table.SelectRows(Source, each List.Contains(List.Buffer(FilterList), [ColumnNameBeingFiltered]))
--Nate
shuhn1229
2 years agoResolver I
Hi,
If I do this I get the following error: Formula.Firewall: Query ‘____’ (step ‘____’) references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Is there anyway around this?
Thx
shuhn1229
2 years agoResolver I
figured it out, ignore privacy.