"Power Query Error: Formula.Firewall and Privacy Level Errors"
This isn't a syntax error or a bug in the query — it's Power Query's Formula Firewall refusing to combine data from more than one source until it knows whether that's actually safe. Combining a private/organizational source with a public one (an internal database and a public web API, for example) can leak data from one into the other; the firewall blocks it by default rather than guessing. Why…
We haven't written up this one. Dev.to has the full story — the link below goes straight to it.