Formula.Firewall: Query references other queries, so it may not directly access a data source.

First of all, this link mentioned no longer exist, so this is definitely not a solution.

Then. In my scenario, I've defined a transformation for a JSON file from a known format as a formula. This transformation DOES use data from other sources, because it's exactly what makes it useful as a formula, and the very reason for it to be converted into a formula.

Problem is, this formula becomes useless due to this error - unless I go and apply the security settings fix.

I understand this won't work in the cloud. But then, how to fix it AND keep the formula useful?