Forum Discussion

paulvans182's avatar
paulvans182
Helper III
6 years ago
Solved

Invoke Function: Reference Query using Query name as parameter

Good morning,    I am busy experimenting with invoking functions in Power BI. I am trying to find a method of Referencing a Query using Invoked Functions.   I thought I could use the following: ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi paulvans182 

     

    Sorry, probably misunderstood the original requirement.

    try this

    = ( strQueryName as table ) =>
let
    Source = strQueryName 
in  
    Source

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi paulvans182 

 

Sorry, probably misunderstood the original requirement.

try this

= ( strQueryName as table ) =>
let
    Source = strQueryName 
in  
    Source

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

nfuids's avatar
nfuids
New Member
3 years ago

I have a very similar situation, but instead of trying to reference a query/table, I want to reference a Parameter defined in my PowerBI file (not a function parameter).

So I basically have a parameter that
TrainA = "ID OF TRAIN A"
TrainB = "ID OF TRAIN B"

and I would like to be able to tell which of the 2 parameters should my function use. 
like 
myTable = CallMyFunction("TrainA"). Inside my function, I do NOT want the text "TrainA" but rather the ID of train A.

I dont see a parameter type of "parameter" as you proposed with the table type. Any way around this?