Forum Discussion

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
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

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: