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

Yvan HOEFMAN on 01 Nov 2021 12:14:44

RE: Accessing multiple datasets in single report

it's a must have to report management kpi's in one report from multiple source.
Today it's possible in Excel, but it would be so efficient to have it in Power BI Service.

's profile image Profile Picture

Michelle Dyason on 11 Aug 2021 20:04:29

RE: Accessing multiple datasets in single report

Seems to me that unless we can do this, the concept of shared datasets is pointless.  I can not use a shared dataset and combine with other data in any way.

's profile image Profile Picture

Lars Boeck on 05 Aug 2021 12:45:03

RE: Accessing multiple datasets in single report

I do not understand why such a significant feature is not available yet. If you just consider that the data load would decrease so much due to usage of just on central point of truth for each data source.

's profile image Profile Picture

on 16 Oct 2020 08:59:53

RE: Accessing multiple datasets in single report

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?

's profile image Profile Picture

Nasario Alcalde on 11 Jul 2020 13:18:34

RE: Accessing multiple datasets in single report

Many times we have to break our models into multiple datasets for re-usability and to overcome size limitations of combining all data in 1 dataset. There are also many use cases where we would have to compose multiple datasets into 1 PBI report.

This is a must have!

's profile image Profile Picture

Iwona Kosz on 06 Jul 2020 00:17:41

RE: Accessing multiple datasets in single report

the best idea ever

's profile image Profile Picture

Matthew Wang on 06 Jul 2020 00:16:08

RE: Accessing multiple datasets in single report

We need this asap!!!

's profile image Profile Picture

JLSF on 06 Jul 2020 00:13:13

RE: Accessing multiple datasets in single report

A Must Have... someone knows if there is already an opinion from Product owner about this?

's profile image Profile Picture

Enrique Peña on 06 Jul 2020 00:10:34

RE: Accessing multiple datasets in single report

Why? It's not very logic users can't use more than a single dataset in one report. If users have several dataset published at Power BI Service, users should have the chance to combine them to produce new knowledge, without duplicating over and over again the data. Users could make relationships from Power BI Desktop, and they would be responsible of doing that in the right way.
Dashboards are not he solution, because users could need to have multiple pages, need to publish to the web, or simply the need of build their reports in the Desktop environment.

Please allow users to make reports from multiple PowerBI Service datasets.

's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:09:33

RE: Accessing multiple datasets in single report

Must have !

Merged Idea (1)