Dynamic M query parameter

[pbihani]

Hi,

I have a requirement as follows:

-> when the report loads, users is prompted to select a product.

-> in the backend, the selected product is filtered from the dataset (uploaded using CSV file), and the required details are sent to the python script with does the required manipulations.

-> the output of the python script is visualized in power bi desktop.

I was able to achieve the above steps, only issue being that I can select only one value in the dynamic M query parameter implementation. How can i achieve it for multiple values (given I am not using DirectQuery and 'bind to parameter' option is missing for me).

Also, if anyone can help me with an alternate to filter the data from power bi desktop without user entering power query editor will be most welcomed.

Thanks,

Pooja

[v-kelly-msft · Accepted solution]

Hi @pbihani ,

Try custom funtion:

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!