The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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!
User | Count |
---|---|
62 | |
57 | |
54 | |
51 | |
33 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
43 |