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!

     

amitchandak's avatar
amitchandak
Super User
5 years ago

robon , Do you mean power query parameter?

  • 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:)