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!

     

    query to parameter.pbix28 KB
v-kelly-msft's avatar
v-kelly-msft
Community Support
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!

 

query to parameter.pbix28 KB
robon's avatar
robon
Frequent Visitor
5 years ago

Thanks Kelly, 

I replaced the parameter and now it is working great.

I'am really happy with this Thanks again

 

Rob