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

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?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

xmark,

When you choose "Import" mode in Power BI Desktop to connect to your tabular models, the PBIX file has 1GB limitation once you publish the report to Power BI Service.

If you don't want to purchase Premium, use "Connect live" mode instead to connect to your tabular mode, in  this case. the PBIX file you publish to Power BI Service don't have 1GB limitation.

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    Hi Anonymous, xmark 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 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?

     

    All the best

    Rob

  • okusai3000's avatar
    okusai3000
    Helper IV
    4 years ago

    Hi,

     

    In our company we are facing the same kind of problem... one mega big SSAS model or several small ones? So far, this hasn't been an issue, as every department uses their own data, but our Board of Directors needs some KPIs from the mix of different sources, so we have to figure it out how to mix it.... 

     

    The easy way is just a big SSAS Model, but I'm afraid of memory limitations...

     

    Any ideas?

     

    thanks!