Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |