Power QueryExercises

Formula firewall

The mechanism that enforces privacy levels, raising an error when a query combines sources in a way that could leak data.

The firewall error usually appears as Formula.Firewall: Query references other queries or steps, so it may not directly access a data source. Restructuring so that one query reads each source and another combines them usually resolves it without lowering privacy settings.

In the Power Query editor

Shown as an error when refreshing or previewing a query that mixes sources.

Common mistake

Building a value from one source inside a step that also reads another source, such as using a cell from an Excel parameter table inside the same step that calls Sql.Database or Web.Contents. The firewall then can't separate the two and raises Formula.Firewall. Read each source in its own query, reference those queries from a final query that combines them, and pass parameters as values rather than as steps that touch a source. Lowering privacy levels to make the message disappear is a last resort, not a fix. Test the refresh again after publishing, because the service applies its own data source settings.

Learn more

Related terms