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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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 AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors