Query List Parameter causing "references other queries or steps...Rebuild Data Combination" Error

Hi all,

I was working to apply a date parameter to a stored query but the date values, because they are supplied by a separate List Query, are causing the dataset query to throw the following error.

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

Prior to posting this I reviewed Similar Solved Forum Post and a separate link that it referenced and came away with a general understanding of the M query execution precidence and the resoluiton being a matter of nesting the upstream query among the dependant downstream query.

I was looking to get some assistance in restructuring my query interaction because I believe that the introduction of a parameter in to the mix makes things slightly more tricky.

Consider the following dependency chain:

1. Query data set for DimDate.Date values.
2. Convert 'date' column to List Query
3. Create parameter 'ReportingDate' based on List query
4. Pass Reporting date value to separate query, to fetch desired data.

Appropriately nesting steps 1-3 into the 'M' syntax for step 4 is what I'm looking for insight on.

M query snippets:

1. Query data set for DimDate.Date values.
   

   let
   Source = AnalysisServices.Database(ServerInstance, Database, [Query="WITH MEMBER [Measures].Dummy AS 1 SELECT {[Measures].Dummy} ON Columns, {[Month End Date].[Date].[Date].Members} ON ROWS FROM [CUBE]"]),
   #"Changed Type" = Table.TransformColumnTypes(Source,{{"[Month End Date].[Date].[Date].[MEMBER_CAPTION]", type date}})
   in
   #"Changed Type"

2. Convert 'date' column to List Query
   

   let
       Source = AnalysisServices.Database(ServerInstance, Database, [Query="WITH MEMBER [Measures].Dummy AS 1 SELECT {[Measures].Dummy} ON Columns,  {[Month End Date].[Date].[Date].Members} ON ROWS FROM [CUBE]"]),
       #"Renamed Columns" = Table.RenameColumns(Source,{{"[Month End Date].[Date].[Date].[MEMBER_CAPTION]", "Date"}}),
       #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}),
       Date1 = #"Changed Type"[Date]
   in
       Date1

3. Create parameter 'ReportingDate' based on List query
   

   #date(2016, 1, 1) meta [IsParameterQuery=true, ExpressionIdentifier=DimDate, Type="Date", IsParameterQueryRequired=true]

4. Pass Reporting date value to separate query, to fetch desired data.
   

   let
       Source = AnalysisServices.Database(ServerInstance, Database, [Query=
       " SELECT { } ON ROWS,
       {[DimDate].[Month].[Month].Members}
       FROM ( SELECT ( { [DimDate].[Year Quarter Month].[Month].&["& Number.ToText(Date.Year(ReportingDate)) &"]&["& Number.ToText(Date.Month(ReportingDate)) &"] } ) ON COLUMNS FROM [CUBE])
       WHERE ( [DimDate].[Year Quarter Month].[Month].&["& Number.ToText(Date.Year(ReportingDate)) &"]&["& Number.ToText(Date.Month(ReportingDate)) &"] ),
       #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns", **Etc.**
   in
       #"Changed Type"

Notice that the date parameter selection is passed into the final query with Number.ToText(Date.Month/Year()) functions.

Granted this is more of a mouthful of a question than I'd like, help in seating these M query parts into a single pass that power BI will evaluate and accept would be greatly appreciated.

Thanks