Forum Discussion
Need help understanding “Formula.Firewall: Query references other queries error
Hi, MAVIE
The error you're encountering, the "Formula.Firewall" error, is a common error in Power Query and it's usually related to Power Query's privacy settings. Power Query is designed to prevent information from being inadvertently shared across data sources. The settings that control this behavior are known as privacy levels, and they are applied to each data source you connect to in Power Query.
When two queries are combined and Power Query can't determine the privacy level of the sources, it blocks the execution of the combined query and gives a "Formula.Firewall" error.
Even though you've set your privacy level to "Organizational", there could still be other issues causing this error. Here are some possible solutions to this problem:
Ensure Privacy Levels are Correctly Set: Although you mentioned you've set your privacy levels to "Organizational", you might want to double-check this setting. Sometimes, privacy settings may not have been applied correctly, especially if you have multiple data sources.
Use Power Query's 'Merge Queries' Option: If you're not already, consider using Power Query's 'Merge Queries' option rather than the Table.Join function. This could sometimes help in avoiding the firewall error.
Enable 'Fast Combine': Enabling 'Fast Combine' could potentially resolve this issue. 'Fast Combine' essentially tells Power Query to ignore privacy levels. You can enable 'Fast Combine' in Power Query Options under the Global Privacy section. However, be cautious with this setting as it might not be advisable if you're dealing with sensitive data.
Use Staging Queries: Staging queries can help when dealing with complex transformations. Each staging query should load data from only one source. Then, create a final query that merges the results of the staging queries.
Hi, MAVIE
The error you're encountering, the "Formula.Firewall" error, is a common error in Power Query and it's usually related to Power Query's privacy settings. Power Query is designed to prevent information from being inadvertently shared across data sources. The settings that control this behavior are known as privacy levels, and they are applied to each data source you connect to in Power Query.
When two queries are combined and Power Query can't determine the privacy level of the sources, it blocks the execution of the combined query and gives a "Formula.Firewall" error.
Even though you've set your privacy level to "Organizational", there could still be other issues causing this error. Here are some possible solutions to this problem:
Ensure Privacy Levels are Correctly Set: Although you mentioned you've set your privacy levels to "Organizational", you might want to double-check this setting. Sometimes, privacy settings may not have been applied correctly, especially if you have multiple data sources.
Use Power Query's 'Merge Queries' Option: If you're not already, consider using Power Query's 'Merge Queries' option rather than the Table.Join function. This could sometimes help in avoiding the firewall error.
Enable 'Fast Combine': Enabling 'Fast Combine' could potentially resolve this issue. 'Fast Combine' essentially tells Power Query to ignore privacy levels. You can enable 'Fast Combine' in Power Query Options under the Global Privacy section. However, be cautious with this setting as it might not be advisable if you're dealing with sensitive data.
Use Staging Queries: Staging queries can help when dealing with complex transformations. Each staging query should load data from only one source. Then, create a final query that merges the results of the staging queries.