Forum Discussion

ICRdatalover's avatar
ICRdatalover
Advocate I
6 years ago

Use PowerBI or SSAS for measures and Calculated columns?

Hi everyone,    I know it could be an old topic, I read a bit about this, but its a 2015 conversation and I was wondering if there are any changes.   Im struggling to understand what are the main...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi ICRdatalover ,

 

In my opinion, it can improve performance at most time, For example, the data source and your SSAS server is on-premises, if the dataset is very large and you are connect data source directly by Import Mode, it may take long time to import data into power bi service and generate calculated columns when refreshing dataset. But if you are connecting SSAS by Live Connect Mode, Only the necessary data will be tranport into power bi service to make the report. This may increase the workload of the machine running the SSAS.


Best regards,

 

ICRdatalover's avatar
ICRdatalover
Advocate I
6 years ago

Hi v-lid-msft 

 

Thank you for your answer.

 

I think I didnt express myself properly,  what I like to know if its better in terms of performance create a tabular model through SSAS and conect it to Power BI, using it mostly for visualization or create all the semantic layout in PowerBI, model, relationships, roles, measures, calc.cloumns etc, conect it to the DWH straight away without SSAS.

 

So is there anything in SSAS-Tabular mode that I can not perform with PowerBI-PowerQuery apart from what I said before?

 

Thank you in advance.!

  • rcanuta's avatar
    rcanuta
    Regular Visitor
    6 years ago

    Hello there,

     

    I have the exact same question.

     

    ICRdatalover did you find some additional information since this thread started?

     

    Many thanks!