Multiple Data Sources : Formula.Firewall - Result of one query to be data source of next

[tbatlanta]

I am stuck with the Formula Firewall error. Any help would be much apprecaited.  I'm hoping this is something easy/obvious that I'm missing.  (I'm a novice at best at advanced queries) 

My full scenario is: 

1. I'm emailed a link daily to download a .CSV file (this link changes daily)  

2. In Flow, I parse out the URL link, pass it to Azureblob storage within a .txt file.  (The download link is not a .csv extension so I could not use a GetContents function.  When you click the link, a file automatically downloads) 

3. PowerBI can successfully connect to AzureBlob and retrieve the URL.  Then the query drills-down to the URL.  See below.  

let
    Source = AzureStorage.Blobs("XXXX"),
    genblob1 = Source{[Name="genblob"]}[Data],
    #"https://XXXX blob core windows net/genblob/_XXXXDataURL txt" = genblob1{[#"Folder Path"="https://XXXX.blob.core.windows.net/genblob/",Name="XXXXURL.txt"]}[Content],
    #"Imported CSV" = Csv.Document(#"https://XXXX blob core windows net/genblob/_XXXXURL txt",[Delimiter="#(tab)", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    Column1 = #"Imported CSV"{0}[Column1]
in
    Column1

I then am trying to use that link as part of the WebContents to retrieve the data.  My assumption is I could refer to my genblob query from above. 

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents(genblob), null, null, 1252)})
in
    Source

However, I can't.  I get the  Formula.Firewall: Query 'Data' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination error.  

I've confirmed the link 'can' be used as a datasource by copying the link and pasting it into a simple Web Data Source. 

let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://mandrillapp.com/track/click/3xxxxx6/assets-xxxxxx-com.s3.amazonaws.com?p=eyJzIjoiTUpfUktObC00R2xiSxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNcIjpbXCI0NzcyYzJlZDQ4ZjRkMTc1Nzg1NjBmNjFmZTA5YTZiMTgzODUzNDc0XCJdfSJ9"), null, null, 1252)})
in
    Source

Thanks again!   Do i just need to run these together? 

[v-deddai1-msft · Accepted solution]

Hi @tbatlanta ,

According to  Data Privacy Settings In Power BI/Power Query, Part 3: The Formula.Firewall Error, the privacy level of  multiple data sources could cause the issue.

You really need to  combine all the queries into a single query. Please refer to

/*There is another way to avoid the error. In all the examples above I have two queries: one to get data from Excel, one to get filtered data from SQL Server. If these two queries are combined into a single query, it doesn’t matter if data from different data sources is accessed in the same step. */  in Data Privacy Settings In Power BI/Power Query, Part 3: The Formula.Firewall Error

Best Regards,

Dedmon Dai