Forum Discussion

xmark's avatar
xmark
Helper I
8 years ago

Multiple tablular models

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 ...
xmark's avatar
xmark
Helper I
8 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    xmark
    Helper I
    8 years ago

    Thanks 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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      xmark,

      You can rename the PBIX file or Excel file to .zip and check the size of the data model file within. For more details, please review this blog.

      Pro users still have the 1GB limit.


      Regards,
      Lydia

      • xmark's avatar
        xmark
        Helper I
        8 years ago

        hi Anonymous thanks for the reply, sorry for my slow response.

         

        I think I may have confused you, I wasnt talking about an excel workbook. I am specifically talking about a SSAS tabluar model (or multiple models).

         

        If my tabular model, which reflects the entire company's data footprint, exceeds 1GB what are the options, (other than upgrade to Premium)? Can we request a size limit increase?