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.
Hey All,
I am running multiple stored procedures from the Power BI desktop on the SQL server. Using the query editor, I am passing parameters defined by me to the SQL server.
All of the stored procedures/queries take ProductID1 and ProductID2 as parameters.
I am not sure how to make this parameter accessible to a user once I publish this report.
Please suggest.
Thanks!
I'm looking for the same except my parameter is the source database name, not sure if its possible but trying to give user an option to choose "Test" or "PRod" server as source to show some metrics. I can select it in the Transform editor but it would be great if this can be a toggle or some input from the user.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |