Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Passing Parameters from an Excel table to MS SQL query

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, wh...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.