power query RRS feed

  • Question

  • Hi, 

    Hopefully somebody could help me with the following. I have basically tried everything to use a parameter in power query to get my source location and use this parameter in a query, but in each situation i bump into the formula.firewall notification due to incompatible privacy levels. I tried to use a function and restructured with staging queries but still I run in the formula.firewall issue. Problem is that we use citrix and each time the privacy levels are put back.

    Is there a solution to use a parameter in a query and circumpass the privacy settings and not bump into the formula.firewall notification?

    Thanks in advance, 


    Saturday, June 1, 2019 5:41 AM


  • Hi Michiel. What version of PQ are you using? The Firewall contains logic that recognizes parameters and attempts to allow them to be referenced from data source queries. However, if you're running on an older version of PQ your Firewall may not contain this logic.


    Friday, June 14, 2019 6:48 PM