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.
So we can bind an existing field with predefined values to a Power Query parameter and pass it to SQL. Great!
But what if I need enable user to insert ANY value (perhaps ID) and bind that to parameter. Is there any way to achieve that? Help needed! Thanks!
@SwiatLudzieTy , based on what I got,
You can have M paramater and replace that in SQL step of power query
"Select * from table where col = " & Mparam
or refer
https://community.powerbi.com/t5/Desktop/Bind-Parameter-not-work/m-p/3034608
Hello Amit, unfortunately it does not answer my question. My main question is how to allow user enter free text in report (something similar to slicer, but allowing entering any value) which will be bound to PQ parameter.
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 |
---|---|
96 | |
92 | |
81 | |
70 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |