Forum Discussion

SjoerdV's avatar
SjoerdV
Frequent Visitor
6 years ago
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 switch between Dataflows via a parameter. This is where I'm affraid I need a bit of help.

 

So I've got 2 Dataflows (A and B) that are added in Power Query, I also have a parameter with text-values A or B.

 

To start, I reference in my fact_query the source-step as follows; = Table.SelectColumns(A,{"colums"}). As A is the table to reference, I tried various options of "&parameter&". This works, but it would only see a single-column that consists of A. So how can I tell Power Query I expect it to look into Dataflow A?

 

Can you guys help me with what I'm missing here?

 

Many thanks in advance.

 

Sjoerd

Need Help

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi SjoerdV 

    As tested, it works on my side.

    I can edit parameters to change my dataflow in Power BI Desktop.

     

     

    Best Regards
    Maggie
    Community 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.
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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
    • SjoerdV's avatar
      SjoerdV
      Frequent Visitor
      6 years ago

      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!