Forum Discussion
Formula.Firewall Error
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
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.
2 Replies
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.
Thanks for your help,
I just combined two queries and all is good.
Z
