Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
pbihani
Regular Visitor

Dynamic M query parameter

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

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

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!

View solution in original post

1 REPLY 1
v-kelly-msft
Community Support
Community Support

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!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.