Passing Parameters from an Excel table to MS SQL query

[Anonymous]

I am using Excel 365.

I have a Power Query (PQ) that reads off a MS SQL database. I need to set parameters for that query from a table in the same Excel workbook.

I created the parameters in PQ, when I feed them manually the query works but when I link those parameters to the Excel table get the following error message

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

I changed the security settings, but it did not work.

I've seen several posts that work in instances where both data sources come directly only from Excel.

Thank you in advance

[Anonymous · Accepted solution]

Hi @Anonymous ,

Here’s one of the point provided in the Microsoft documentation:

When combining or merging data between multiple data sources, you might get a Formula.Firewall error such as the one shown in your case.

This error can be caused by a number of reasons, such as the data privacy levels between data sources or the way that these data sources are being combined or merged. For more information about how to diagnose this issue, go to Data privacy firewall.

Below is a solution provided in a similar thread, hope it would help you.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vijay_A_Verma]

Solve this with help of this - https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ 

If you need to know technicals behind this - https://docs.microsoft.com/en-us/power-query/dataprivacyfirewall