Skip to main content

Power BI

Needs Votes

Accessing multiple datasets in single report

Vote (195) Share
's profile image

on 24 Feb 2016 14:51:10

I uploaded several datasets already available to me, and now i want to create a single report using them. Can there be a way to refer to multiple datasets in a single report?

Comments (33)
's profile image Profile Picture

James Houck on 05 Jul 2020 23:36:18

RE: Accessing multiple datasets in single report

Total must have. This could be the reason customers turn to other products or tools.

's profile image Profile Picture

Chris Dopler on 05 Jul 2020 23:34:31

RE: Accessing multiple datasets in single report

This feature would add tremendous flexibility in our scenario. MUST HAVE!

's profile image Profile Picture

Chris Smith on 05 Jul 2020 23:34:02

RE: Accessing multiple datasets in single report

This would be very handy in an enterprise setting. We could have individuals do the work to create the datasets and control their refresh schedules, and they could publish those sets out to analysts to use in their own reports.

's profile image Profile Picture

Josh LaSov on 05 Jul 2020 23:31:59

RE: Accessing multiple datasets in single report

This is a must! This will take auto-refresh to a whole new level and allow PowerBI to compete so much more effectively over Tableau and Qlik - which both can do this.

's profile image Profile Picture

Sedat on 05 Jul 2020 23:29:29

RE: Accessing multiple datasets in single report

Extreamly required

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:05

RE: Accessing multiple datasets in single report

Seems crazy not to be able to do this. If you have a lot of historical data you can query it into a dataset, and not have to refresh it all the time... it can just be there. Then you would only have to query going forward...

's profile image Profile Picture

Steve Thompson on 05 Jul 2020 23:10:16

RE: Accessing multiple datasets in single report

Really need this as the speedy proliferation of data sets starts to get very untidy, very quickly.
Even the option to use a Power BI service source to drive an existing report by manually changing the fields. Laborious but at least reports can share data sources.
It's not as if they are similar sources - they are the same

's profile image Profile Picture

Marius on 05 Jul 2020 23:07:42

RE: Accessing multiple datasets in single report

This is a feature that we really need as well in order to utilize Power BI's potential.

's profile image Profile Picture

Sridhar Manickavel on 05 Jul 2020 22:54:21

RE: Accessing multiple datasets in single report

From OMS we can configure to push data to Power BI, but it is creating separate dataset for each OMS rule/queries. If we need to create single report from multiple dataset then it is not possible.

We need to have filters at report level from multiple dataset. Dashboard also not solving this usecase. OMS is not having enough option to view the data or enlarge the graphs.

's profile image Profile Picture

Sunkari on 05 Jul 2020 22:21:16

RE: Accessing multiple datasets in single report

We required this functionality

Merged Idea (1)