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 contain...
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!

     

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!

      • robon's avatar
        robon
        Frequent Visitor
        5 years ago

        Sorry for my late responce. thanks i gonna try this today i keep you updated thanks again!