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
dimarmir1720
Frequent Visitor

Pros and cons of using multiple dataset in a single power bi report

I have several dataset, now I want create a report with multiple datasets to avoid rework.

 

I want understand pros and cons of using multiple dataset in a single report.

6 REPLIES 6
v-xiaotang
Community Support
Community Support

Hi @dimarmir1720 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.


Best Regards,
Community Support Team _Tang

I didn't solve the problem yet, the solutions presented are good and helped for sure, but it showed me how to use composite models instead explain better the pros and cons for a long-term use perspective. 
I want more feedback before changing my reports using the composite model.

 

 

v-xiaotang
Community Support
Community Support

Hi @dimarmir1720   

I want understand pros and cons of using multiple dataset in a single report.

you can take a look at this answer, 

https://forum.enterprisedna.co/t/multiple-datasets-in-same-report/14122/2

https://www.youtube.com/watch?v=9lkVk4t2qL0

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

mussaenda
Super User
Super User

Hi @dimarmir1720 ,

 

We actually do this on Direct query then publish the report with no visuals

and then create new reports using power bi datasets. 

 

But if the multiple reports you are talking about are completely not related, 

It is better to separate them.

 

Hope this helps.

The main idea is to avoid rework on others models.

I have a big amount of data and datasets are different right now, now I want creat a composite model that now is possible on power bi.

Before starting creating reports I want understand well pros and con of this technic.

amitchandak
Super User
Super User

@dimarmir1720 , Are you taking about mutiple power bi datasets ?

 

If need refer video link at the end of this solution

https://forum.enterprisedna.co/t/multiple-datasets-in-same-report/14122

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.