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

[dimarmir1720]

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.

[v-xiaotang]

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

[dimarmir1720]

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]

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]

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.

[dimarmir1720]

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]

@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