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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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