Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Formula.Firewall Error using CSV string in (step 'Source').

ErrorMessage: Query 'Query1' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.   DataSource Settings: 1) "Datab...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    How about add custom steps to get data from CSV file and invoke SQL connector in same query table?

    For example:

    let
	list=Csv.Document(File.Contents("xxxxxxxx")),
	merge="'"& Text.Combine(list,"','")&"'",
	Source=Sql.Database("xxxxxxx","xxxx",[Query="select xxx from xxx where code in ("&merge&")")
in
	Source

    Notice: please setting 'data privacy' to 'public' to prevent the error of cross source invoke.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

How about add custom steps to get data from CSV file and invoke SQL connector in same query table?

For example:

let
	list=Csv.Document(File.Contents("xxxxxxxx")),
	merge="'"& Text.Combine(list,"','")&"'",
	Source=Sql.Database("xxxxxxx","xxxx",[Query="select xxx from xxx where code in ("&merge&")")
in
	Source

Notice: please setting 'data privacy' to 'public' to prevent the error of cross source invoke.

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

 

Can you please also show me an example of the same thing but using a SQL datasource which returns just 1 database field? 

 

Thanks!!