Formula.Firewall Error

[zibster]

Hi

I am stuck with the following error

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

my M code is below please help

Thanks Z

let

Criteria01 = DateT,
Source = Odbc.Query("dsn=Snowflake Dev", "select top 10 *#(lf)#(lf)From#(lf)dw_dss.TXN_TAX#(lf)where txn_dte = '"&DateT&"'")
in
Source

[edhans · Accepted solution]

You need to give DateT and your Snowflake data source the same level of permissions in data source settings. Power QUery is preventing you from sending confidential data from one source to another. See this article for a deep dive.

[zibster]

Thanks for your help, 

I just combined two queries and all is good.

Z