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.
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
Solved! Go to 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!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |