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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.