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 All,
Im hoping to set up a run query button. I have a report which passes multiple parameters into a SQL query in direct query mode. My report has multiple filters such as date, user, etc. and I would like an end user to be able to set all the parameters first and then run the query using a button or an alternative idea. Currently it would run each time a user changes each parameter which is not ideal
If anyone has any ideas, it would be much appreciated.
Solved! Go to Solution.
@kdbuser , You can have concepts like parameter page. I discussed this in these two videos. Using Slicer sync and page navigation
Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15
New means to access display pages - Display only one page in the report, Hide the rest: https://youtu.be/d4H0GKUH0r4
Thanks thats exactly what I needed
@kdbuser , You can have concepts like parameter page. I discussed this in these two videos. Using Slicer sync and page navigation
Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15
New means to access display pages - Display only one page in the report, Hide the rest: https://youtu.be/d4H0GKUH0r4
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |