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.
Hello all,
Firstly my aplogies as this may have been covered before, but I can't find a clear answer now.
I have a dataset based on one business area. I have a 'Monthly Station Report' that allows the user to select the month and station (actually Fire Station in my context) to provide key data for the given station in the given month. This is fine for the one business area, but I've now been asked to include data from a different business area, which is currently within a different dataset.
I'm aware of two options:
1. Create a new dataset that includes data from both business areas. This is not very attractive as both existing datasets are reasonably complex, and ultimately I'm expecting to need to include a number of business areas.
2. Create a dashboard and include two reports, one from each dataset (and business area). Not the most elegant, and I believe the user will have to seperately select the month and station for each report seperately.
Are there any other options open to me? I'm really surprised that one can't construct a report based on multiple datasets.
Your advice and comments would be appreciated.
Thanks
Andy
Solved! Go to Solution.
Thanks so much for the quick reply @negi007 , it's really appreciated. It's great to see this is possible, and (so far) really easy to do. I just have to make sure I have valid relationships betwen the different datasets now!
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |