Parameter from Query

[Anonymous]

Hi,

I was trying to use a separate Excel File with a table as a Parameter List, so far so good...

Made a query, made a drilldown fine. Now that it's a list, or maybe I think it's one but it's not handled as one.

What must I do to perform such a thing?

Table to Query and DrillDownParameter from DrillDown

I made a parameter list as a test inside of the power query module and get a list and I can change the parameters with a combobox. But the table query which I made a drilldown with is just a single text field. What must be done to make a table to a list of parameters?

Parameter from created List in PowerQuery

Kind regards

Sam

[mahoneypat]

Not totally clear what you are trying to accomplish, but one option to consider is to reference each of the items in your List (or Table) and use them separately (e.g., List{0} to get the first item of the list) in other query(ies).  Does that help?  If not, can you provide more details?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

Hi @mahoneypat 

I will try to explain. I have different parameters. But instead of typing them manually into a list in power query, I wrote a Excel File and load it as a query made a drilldown and want to use it as a parameter list. But in the parameter selection I just get a textbox with and no combobox selection like if I had written the parameter manually as a list in power query.Manuel List to ParameterManuel List ParameterExcel Query List to ParameterExcel Query List Parameter

Excel Query List

That is the M Code for the Parameter from the Excel File

"08" meta [IsParameterQuery=true, ExpressionIdentifier=dt_pg, Type="Text", IsParameterQueryRequired=true]

This is the M Code for the Manuel List Parameter

"08" meta [IsParameterQuery=true, List={"08", "17", "23", "24", "31"}, DefaultValue=..., Type="Text", IsParameterQueryRequired=true]

How do I get the ExpressionIdentifier into a List?

Hope that was better explained than before :).

Kind Regards Sam

[mahoneypat]

Thank you for the additional explanation.  The approach  by suggested by @Anonymous should work.  Please let me know if not.

Regards,

Pat

[Anonymous]

Hi @Anonymous ,

You can refer the following documentation to achieve it.

Populate a Power BI parameter list using a query

Best Regards

Rena

[Anonymous]

@Anonymous 

Yeah that's the way I Did it but I was using power query in Excel not PowerBI (so the edit parameter is missing) i can just change the parameter in power query. can I adjust the m code to perform the "list" from the excel file as parameter?

[Anonymous]

Hi @Anonymous ,

Please check if the following documentations can help you.

Create A Parameter Table For Your Power Queries

Power Query Parameters – How to use Named Cells as Flexible Inputs

Power Query – Using Parameters

Best Regards

Rena

[mahoneypat]

If you've made a query that results in a list of the desired parameter values (not a table), you can use that query in the Suggested Values for a parameter.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat