Formula.Firewall

[Analitika]

Formula.Firewall: Query 'XLS_Source' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

= Excel.Workbook(File.Contents(Path_from_settings & "/" & Sas_file_Name), null, true)

Path_from_settings ' query from Settings_Path

Settings_Path

= csv[Column1]{0}

CSV

let
Source = Csv.Document(File.Contents("C:\csv.txt"),[Delimiter=",", Columns=1, Encoding=1257, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}})
in
#"Changed Type"

[PhilipTreacy]

Hi @Analitika 

There's not quite enough information to go on here.

Can you please share the XLS_Source query that is generating the error.

From what I can make out you have a query called CSV which reads the file c:\csv.txt to get a path which is referenced by another query Settings_Path.

Is that then used in XLS_Source?

Please provide as much information as possible, like all the queries.

Phil