cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Giogunner
Frequent Visitor

PBI SSAS Live Connection multiple models

I just found out that multiple models of SSAS Tabular cannot be connected to one PBIX file. So my question is, should I deploy all the tables in one model or create several models where I will have some of the tables duplicated?
Which will give me better performance? 

2 REPLIES 2
josef78
Super User
Super User

You can create single big model which contains all what you need. Tables in model can be connected by some relation or not (in model you can have some independent part/group/island of tables without any connection), but I recommend use perspectives to avoid misunderstanding in large model.

 

From query performance there no difference if you have some tables in multiple models or in single model (but be carefully if all tables are connected by relations). Also there no difference about processing performance, every object you can process independently. And there are two pros: you can connect and use from single Power BI report, and you can save memory usage (and process cpu time) by duplicated tables in more models.

 

By my opinion, there is single cons, it is about development and maintenance, is more difficult to develop and keep developing cycle for single large model (especially if is developed by multiple developers) than more simple independent models.

Icey
Community Support
Community Support

Hi @Giogunner ,

 

To my knowledge, it would be better to create several models than one model. For each model, optimize it for its specific purpose. And it will result in a much better performance than trying to fit all requestments into one model.

 

Then you can create a report for each model and then create a dashboard based on them.

 

Best Regards,

Icey

 

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

Helpful resources

Announcements
collabdays lisbon

CollabDays Lisbon - 26 November 2022

Sessions include practical, hands-on experience that will help you take the next step in your career and know-how.

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.