Power QueryExercises

Privacy levels

Labels (Private, Organizational, Public) that stop Power Query from sending data from one source to another.

When a query combines a Private source with a Public one, Power Query won't send the private values to the public source, for example inside a web request URL. Setting levels correctly, rather than ignoring them, keeps refreshes working in the Power BI service as well as on the desktop.

In the Power Query editor

File → Options and settings → Data source settings (Power BI) or Get Data → Data Source Settings (Excel).

Common mistake

Setting every source to None or ticking Ignore the privacy levels to make an error go away. That can let data from a private file be sent to another source, and it often fails anyway once the report is published, because the Power BI service applies the levels set on the gateway or dataset. Give each source the level that matches who may see it, usually Organizational for company systems, and fix the query structure if the combination is still blocked. Levels are stored per data source, so check them again after changing a server name or file path.

Learn more

Related terms