Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |