Forum Discussion

mlozano's avatar
mlozano
Icon for Helper III rankHelper III
4 years ago
Solved

Power query dynamic filter error

I am trying to create a dynamic filter with power query parameters, my data source is an Azure SQL database, the intention is to be able to filter the data by region dynamically from the report view....
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi mlozano ,

     

    This is because your Region query are sourced from other data sources or the same data source, causing the Power Query firewall error, please go to Options -> Privacy, and disable privacy.

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi mlozano ,

 

This is because your Region query are sourced from other data sources or the same data source, causing the Power Query firewall error, please go to Options -> Privacy, and disable privacy.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.