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 there,
I am looking to create a dashboard /report for my users to see business on the books (hospitality KPI- this basically needs to tell us how many are the no of rooms booked for the rest of the year from current day ). I have the query I run in SQL to get the results out but they needs 4 parameter inputs ((1) Hotel Id , 2) current date , 3) startdate, 4) enddate)). How can I use this query to create a real time dashboard to show on the books data (future data to be displayed each day real time).
Please advice.
Many thanks
Preveena
In Power BI Desktop, we can apply the Query Parameters to filter different records based on selection. However, it doesn't work on Power BI Serivce, which means it can't be used for creating dashboard. Please vote this idea.
For your requirement, you can also try SQL Server Reporting Services.
Regards,
Simon Hou
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |