Formula.Firewall: Query 'q' (step 's') references other queries or steps, so it may not...

[BedoToledo]

Hello.

I am getting following error:

Formula.Firewall: Query 'q' (step 's') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

The error arises randomly every few minutes, in queries which reference other queries. For example: I am reading a single date from a file, to create a cutoff date for other queries. The date is a separate query, and has only one value as output. Then in another query, I read a file, and then remove all values which are earlier/later than the date. At this point I randomly get this error. This is not consistent, and I can get it in the same query which has worked a few seconds before. If I relaunch power BI and refresh all previews, it dissapears for a few minutes.

I would appreciate any help - it is extremely hard to work when I have to wait for PBI to relaunch half of the time. Thank you in advance.

[BedoToledo]

What do you mean here by "refactor your queries"?

Both files in question are in the same folder, with same access. The only failure point is that I take the other file via function. Do you suggest using duplicate code instead of a function?

[lbendlin]

Either that or bring the function inline to the query.

[lbendlin]

first test if the problem goes away when you set privacy levels to none.  Then set them back to organizational and refactor your queries so that the ones causing the error message are in the same partition.