Forum Discussion
Multiple tablular models
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.
Regards,
Lydia
Hy Lydia,
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 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 tabular data source?
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,
LydiaThanks Anonymous
In order to 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?