Renato Lira on 15 Oct 2020 20:29:29
Imagine This:
You have a Dataset A that has complex DAX measures for several KPIs your company needs.
You have a Dataset B that uses the result of the KPIs in an aggregated manner as an input, but doesn't need all the data to recalculate it. Dataset B only needs the precomputed KPIs as an input that is completely evaluated in Dataset A.
Today one alternative is to use DAX Studio that connects to Dataset A to perform a DAX query and save a TXT output file. Then manually feed it to some dataflow so it can be used as a source for Dataset B.
Instead, if the Power BI allowed a Dataflow to connect to a Dataset and perform a DAX query over Dataset A, the Dataflow could automatically feed the Dataset B with this new data on the next scheduled refresh.