Power BI Connections and parameters

[pjhowcroft]

so ive trawled over google and have got to a point i cant get pass. so..
1. i have a parameter that lists and selects files from a folder
file list query (parameter uses on this)
let
Source = Folder.Files("\\BAESTNWAR003v01\Warton2_phillip.howcroft$\Documents\Availability - New Capability\OO_Conversion\Old"),
#"Added Custom" = Table.AddColumn(Source, "File", each [Folder Path]&[Name])
in
#"Added Custom"

2. i then have a query that uses the parameter to selct a file i want to use;
let
SolutionPath=FileList,
Source = Excel.Workbook(File.Contents(FileList), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true])
in
#"Promoted Headers"

the solution path allow me to check that what i have selected is being passed to the source but it errors out. if i point it direct at that file it loads correctly when i use the parameter it gets the useless error;

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

ive cleared permissions and everything, it doesnt work, yet everything i can fins on the web says it should.

 

[Matt Allington]

The easiest solution is to turn off privacy settings for the workbook in the settings. Set it to “ignore”

 

[pjhowcroft]

The easiest solution is to turn off privacy settings for the workbook in the settings. Set it to “ignore”

are you refering to the connection privacy settings? they were set at "none"