Hi all,
I am using calling an API and I have queries 1-4.
I appended queries 2-4 to my first query number 1.
My first query is throwing out the following error code in the advanced editor:
Formula.Firewall: Query 'Table' (step 'Replaced Value4') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
I have seen another post about this but the following link posted for it looks at Excel so I couldn't quite follow it and was wondering if anyone may be able to help at all? https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
My code is as follows:
Source = Json.Document(
Web.Contents(
"https://",
[
Content = content,
Headers=[
#"X-Api-Key"="XXX",
#"Content-Type"="application/json"
]
]
)),
result1 = Source{[Item="result1"]}[Data],
#"Converted to Table" = Table.FromList(result1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "country", "segment"},{"id", "country", "segment"}),
#"Appended Query" = Table.Combine({#"Filtered Rows", Table_Retail}),
#"Appended Query1" = Table.Combine({#"Appended Query", #"Table (2)"}),
#"Appended Query2" = Table.Combine({#"Appended Query1", #"Table_Retail (2)"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","weeksalesvalue","Week Sales",Replacer.ReplaceText,{"ROS_Aggregate_Type"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","matsalesvalue","Year Sales",Replacer.ReplaceText,{"ROS_Aggregate_Type"}),
#"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","week4salesvalue","4 Week Sales",Replacer.ReplaceText,{"ROS_Aggregate_Type"}),
#"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","quartersalesvalue","Quarter Sales",Replacer.ReplaceText,{"ROS_Aggregate_Type"})
in
#"Replaced Value4"
From what I understand, it is the error in the last line that references the line before it? And it needs to reference the external code? Does anyone know what that should be?
Apparently going to the following fixes the issue: Options --> CURRENT FILE --> Privacy then setting the Privacy Level to "ignore the privacy levels and potentailly improve performance" but I don't know what ignoring these privicy levels may impact other than this, any ideas?
Thanks in advance!
Lauren.
