Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Reply
Anonymous
Not applicable

Create Report from Multiple Datasets

In the new model, can we create a report either in Desktop or Service that pulls from multiple datasets? 

 

With an enterprise deployment, how is the best way to create reports off of multiple datasets? Is it to create separate reports from each dataset and then deploy in an app? What if I want multple dataset components on one report? Can I do that yet? 

 

Thanks!!!

2 REPLIES 2
suyogpatil2002
Frequent Visitor

NOT SOLVED !!!

Who Mark Power Bi Community questions as Solved? These are not really solved but just there is no solution to it. 

In fact there are marked as Feature/Idea/Innovation etc. we developers/report builder unnecessary spend time in reading all the way down to see what is that solution recommended here and finally finds that it is just marked as Solved because there is no solution or Power Bi Limitation. 

 

Anyways, @PowerBI team tell us the solution to this. 

When it is mentioned that DataSet is relational model, we should still allow to pull 2 datasets into single report file without making any relation and developer will do relational part on their own.

TeigeGao
Solution Sage
Solution Sage

HI @Anonymous ,

A report cannot be created based on multiple datasets, a dataset is a full model with relationship and tables, but a dataset can be created based on multiple data source, you can consider the later way.

Best Regards,

Teige

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.