Forum Discussion

pmdci's avatar
pmdci
Advocate V
11 years ago
Solved

Measures and CalcColumns in Power BI vs Tabular model (replace SSAS with Power BI?)

Hello,   I have a data-mart on-premise, and on top of that I have an ssas tabular model.   I've been playing with Power BI on my deskop and I noticed how it allow us to create our own calculated ...
Need Help
  • andre's avatar
    andre
    11 years ago

    You need Analysis Services if you have one of the following requirements:

     

    1. You need to have row level security
    2. Your data set is greater than 250MB
    3. You need to have a fine grained control over how your model is refreshed from the source data (partitioning)

     

    If the aforementioned requirements are not present, then using Power Pivot or Power BI Desktop to build your model and publish it to Power BI is a valid and wonderful choice.

     

andre's avatar
andre
Memorable Member
11 years ago

You need Analysis Services if you have one of the following requirements:

 

  1. You need to have row level security
  2. Your data set is greater than 250MB
  3. You need to have a fine grained control over how your model is refreshed from the source data (partitioning)

 

If the aforementioned requirements are not present, then using Power Pivot or Power BI Desktop to build your model and publish it to Power BI is a valid and wonderful choice.

 

pmdci's avatar
pmdci
Advocate V
10 years ago

Thanks Andre!

 

Actually I got all confused due to the overlap of BI products by Microsoft. But one thing that put it all into perspective for me is that Power BI's modelling features are like PowerPivot in Excel. Once I got that in my mind, then it all made sense.

 

It is simply "PowerPivot for Power BI" -- for the lack of a better term.

 

Regards,

P.