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...
