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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors