Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Community!
I get a well-known firewall error when I try to embed data received from another source (DataFlow) into an SQL subquery. The option "Always ignore Privacy Level Settings" is set in the report settings. This option is designed to make the Firewall ignore security issues such as referring to another query/partition. But the error remains and it seems it remains only for subqueries that use a link specifically to DataFlow sources. Power BI Desktop refreshes the reports, Power BI portal doesn’t ( the above error occurs).
I can indeed rewrite the requests in accordance with the recommendations from here: https://docs.microsoft.com/en-us/power-query/dataprivacyfirewall
Perhaps there are other options that do not require refactoring. I tried to enable the option "Allow combining data from multiple sources" in the settings of the Data Flow source, but it does not help...
Hi @gampy
I have found that the only way to get it working is to refactor as per the suggestion in your link.
Or what I have done is to then put all the queries into a single table to get it to run.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
30 | |
28 | |
23 | |
21 | |
18 |
User | Count |
---|---|
55 | |
37 | |
28 | |
24 | |
21 |