Forum Discussion
Power BI Data Service v Desktop Refresh
Yep. Your only chance ist to stuff everything into a single query. Calling one query from another won't work
Consider using a dataflow for the upstream query.
But that's what I am doing in the attached. Everything happens all in that code, and there are no separate Power Queries getting used. My issue is (I think) that one data source produces a result, that ultimately determines part of a next step that calls another data source... I'm not sure how to get round that part essentially.
Could I fold them into separate "partitions" within one query to make it work?
Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn
I thought that reading the above would get me there but it really hasn't.
I would really really appreciate any further help that you can please offer