Multiple tablular models

Question

I am currently desiging a DW architecture and trying to understand the optimal way to fit Power BI into the reporting and analytics side of the architecture.

Right now the plan is to use SSAS in tablular mode to create models ready for Power BI consumption. However, it appears that Power BI can only conenct to one tablular model at a time...

What is generally best practice in the situation where you have varying data from different business units (finance, HR, memberships, etc.) with respect to creating the tablular models? One big one, or many small ones?

Obviously, if we have many small models, I cannot connect Power BI to many of them at once (as stated above), but one large one means lots of potentially useless data in a single model which could also take a long time to refresh/process.

anonymous · Answer

&nbsp;Hi Anonymous, xmark&nbsp;and others,We are having just this issue at the moment, so any comments will be really helpful.We are working with PBIRS On-Prem, and have a number of medium sized SSAS Tab models we would like to surface measures from on a single PBIX report. Actually we are using this single PBIX report as a kind of PBI dashboard, bringing together measures from a number of lower level, more detailed anaysis. But as On-Prem does not support PBI Dashboards we are using a report to try and simulate the effect.Following the advice that if we IMPORT the multiple SSAS Tab models we can then work with them in one PBIX we went ahead and imported...... we won't be doing that again, it crached the server we were running&nbsp;on. The server crashed because the memory useage went to 99% and SSAS / PBI wanted more. It seems that importing the SSAS Tab model is a very resource intensive process.So we are back to the original question, one large SSAS Tab model or multiple small ones. Looks like we are going to have to go down the one large model. Unless someone has any ideas?&nbsp;All the bestRob

anonymous · Answer

xmark，
&nbsp;
If you choose “Connect to Live” mode in Power BI Desktop to connect to SSAS tabular, you are only able to connect to one model in one Power BI Desktop file. And in this mode, there are some limitations, for example, we are not able to manage relationships, create table/columns using DAX, etc.
However, if you use import mode instead, you are able to connect to multiple tabular models in one Power BI Desktop file. You can create small tabular models and use import mode to connect to there models in Power BI Desktop.
&nbsp;
Regards,Lydia

xmark · Answer

Hy Lydia,&nbsp;Thanks for the reply. So my understanding is correct then... If I conntect using Import mode, I will be downloading lots of data which also&nbsp;has a large downside. If I connect to my tabular models within the Power BI website (via the gateway we have running), can I use multiple models in a single report? Or still limited to the 1&nbsp;tabular&nbsp;data source?

anonymous · Answer

xmark,You can have multiple models in the single report and the report will work in Power BI Service. But please note that if you don't have Power BI premium license, the size of PBIX file and data model in the dataset will be limitted to 1GB. If your dataset exceeds the limitaion, you will get error message when publishing the PBIX file to Power BI Service and refreshing it in Power BI Service.Regards,Lydia

xmark · Answer

Thanks&nbsp;Anonymous&nbsp;&nbsp;In order to&nbsp;perform some capacity planning, how exactly would one go about testing the 'size' of a model? That 1GB limit feels incredibly small, my client currently has Pro, does that still have the 1GB limit?

Forum Discussion

Multiple tablular models

10 Replies

Related content

One Semantic Model for Multiple Reports

multiple or single semantic model

power bi report based on multiple semantic models

One Semantic model VS Multiple Semantic Models

Multiple semantic models