Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need your support to show me how to pass parameters to a sql query and then launch it by cliking on a button in a power BI report. That means, the query will get data after considering the filters choosen by an user.
Solved! Go to Solution.
Hi @ChnYasAns ,
Please try:
First create a parameter that you want to pass to the data source:
Then connect your parameter to your data source like this:
Then create a Parameter table in the data model and bind to parameter:
Now you can use this value to create a slicer that can change your data source:
Note: Dynamic M query parameters (Bind to parameter option) is only available for some Direct Query source.
Please refer to this:
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ChnYasAns ,
Please try:
First create a parameter that you want to pass to the data source:
Then connect your parameter to your data source like this:
Then create a Parameter table in the data model and bind to parameter:
Now you can use this value to create a slicer that can change your data source:
Note: Dynamic M query parameters (Bind to parameter option) is only available for some Direct Query source.
Please refer to this:
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |