Reporting across Datasets

[apt108]

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

[negi007 · Accepted solution]

@apt108 pl. go through below link to understand how you can create a report from multiple datasets. 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

[apt108]

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!