Forum Discussion
Measures and CalcColumns in Power BI vs Tabular model (replace SSAS with Power BI?)
You need Analysis Services if you have one of the following requirements:
- You need to have row level security
- Your data set is greater than 250MB
- 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.
I don't see why not, you will need the Power BI SSAS connector, which supports row level security, here is more info:
Once you suck information into Power BI, or Excel PowerPivot for that matter, it is in a tabular model, so not sure why you would need another tabular model in between.
Hi smoupre,
I think you misunderstood my question.
My question is whether I could simply bypass SSAS, connect straight into the relation DBs and have all measures, calculated columns and relationships that exist in the SSAS created in Power BI instead. Therefore rendering SSAS irrelevant.
Regards,
P.
