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.
Hi!
We are migrating reports from SQL Reporting Services to Power BI. Our reports have parameters in the SQL Query that are used for making calculations, stored procedures and so on. Is there anyway we can make end users change these parameters using a slicer or filter, besides making the query M-based (according to this article Dynamic M Query Parameters) because re-writing our querys will take too much time, as they are really complex.
Here are some examples of what our querys do with parameters.
declare @Anonymous varchar(10) = 'AA'
SELECT Column
FROM Table(@Data)
CASE WHEN @Anonymous = '*' THEN '%' ELSE @Anonymous+'%' END
I will appreciate any idea or suggestions you have.
Hey @Anonymous ,
with Dynamic M Query you are on the right path.
Maybe I don't see your point, but why don't you want to use them?
You can add your SQL Query:
Then add the parameters:
And at the end change the static part in the M-Code to the parameter:
Then whenever the user is changing the parameter, the query will be changed to the selection of the user.
I want the users to change the parameter using a slicer or filter, as stated here Dynamic M Query Parameters but using SQL as my source.
End users can't get into the configurations and change parameters.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |