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

Hello, from my experience, you can indeed use functions to make iterating requests (even in the power BI service). I would advise to avoid making your request functions too complicated though, like accessing multiple sources at the same time or passing data between queries.

That is the best I can say without knowing the details of what youre trying to do right now.