Forum Discussion

robon's avatar
robon
Frequent Visitor
5 years ago
Solved

query to parameter

Hey,

I'am new to Power BI, so maybe you can help me.

I've got a query who pulls a sessionID and a few other thing i need. The sessionID is always changing. How can i create a parameter that contains the changing Sessionid?

 

thanx for your help

Rob

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  robon ,

     

    Have you refreshed data or applied changes?

    As tested here,it works fine:

    For "parameter",modify it as below:

    let
    Source = ()=> let
       
      #"New ID"=Table.FromRecords({Table.SelectColumns(#"Table","Table.SessionID "){0}})
    in
       #"New ID"
in
    Source

    And you will see:

    For the updated .pbix file,pls see attached.

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

10 Replies

    • robon's avatar
      robon
      Frequent Visitor
      5 years ago

      I don't know if i said it the right way. I want to make a parameter from a query result but it has to be just one cell(SessionID) so i can use the parameter in another query.

      Thanx for helping me out, sorry if i ask stupid questions:)

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey robon ,

     

    your description lets some room for interpretation.

    Can you give an example what exactly you need and what exactly you want to do?

     

    Then we can help you better. Maybe another approach is more useful.

     

    Best regards

    Denis

    • robon's avatar
      robon
      Frequent Visitor
      5 years ago

      If got a query that give back the sessionID and other info. I want to use the sessionID in another query. This is the table from the first query that shows the session ID query. The "Table.Table.Table.SessionID" and then the first value i want as parameter (or something else i can use in other query's.

       

       

      Thanx again,

      Rob

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi robon ,

         

        Create a function as below:

        let
    Source = () => let
        Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQz0jNW0lHySE1MSS1SitWJVsorzckBijjlp1QqxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Table.SessionID " = _t, Name = _t]),
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Table.SessionID ", type text}, {"Name", type text}}),
        #"New ID"=Table.FromRecords({Table.SelectColumns(Source,"Table.SessionID "){0}})
    in
       #"New ID"
in
    Source

        And you will see:

        The parameter gets the first value of column "Table.SessionID" and can be used in another query.

        For the related .pbix file,pls see attached.

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!