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

Question

Microsoft seem to have changed how excel and Power Query is able to call native query using parameters created from cells within the document.

I have a simple query which i woudl liek to use a start and end date to limit the amount of rows that are coming back.

The example query could be 'select customer_name from customers where date_created is between STARTDATE and ENDDATE'.

I have set up Start and End date which are cell values using the method of create table from cells drill down to get the right value for each one. And then go into the query within advanced editor and inputting the parameters.

This has worked up to last week but i am now receiving the error below?

Can anyone help with whether i am doing this correctly or not?

Answer 1

Hi @Ben Lunt . Nothing has changed in this area recently. My guess is that you've done one of the following:

• Enabled the data privacy firewall (by turning off privacy level checking in Options), or started a new workbook (where it would be enabled by default)
• Switched ReportStartDate and ReportEndDate from being PQ parameters to being pulled from the worksheet

Have you done either of these recently?