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 

 

Please see the attached file with the example of Invoke custom function.

 

 

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn

 

paulvans182's avatar
paulvans182
Helper III
6 years ago

Hi Mariusz ,

 

Thank you for the suggestion - however, unless i am misunderstanding, your solution appears to add a new column to the already existing table.

 

What I am looking to do, is to create a new query with the same data as the existing query (essentially a duplicate or reference of the query) that I can then manipulate separately.  So, effectively I would have your original Table query, and a new query that looks identical to Table after I invoke the function using the queries name, "Table" as the parameter.

 

Does that make sense?  Thanks again for any help you can provide 

 

Kind regards,

 

Paul