Forum Discussion
Solved
How to select dataflow based on variable?
Hi all, I'm developing a model that get's it input via Dataflows. However, since we want to look at numbers as they were on a cut-off date and with the latest figures available, I'm trying to swi...
Hi SjoerdV
This article should be useful.
https://data-marc.com/2019/04/16/pimp-the-dataflows-connector-in-power-bi/
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie
Many thanks v-juanli-msft !
In the end I created 2 versions of each dataflow (already had that of course), one named A LIVE and the other one A CUTOFF. Then I created a text-parameter with 2 options, LIVE and CUTOFF. After that it was simpy a matter of selecting the workspace the dataflows reside in, filtering on all dataflows that contain "A" and then filter on dataflows names that end on the parameter-value. From there on simply expanding etc etc.
In the end I think I was in the right direction, only wrong with the coding.
Nevertheless, thanks again!
