Forum Discussion

yasbos's avatar
yasbos
Icon for Resolver II rankResolver II
3 years ago
Solved

Measures in SSAS

Hello, Team. I was told that, if my organization has SSAS server, then I should create all of the measures/calculated columns in there rather than in PBI Desktop. Is that true? I am not familiar with...
Need Help
Tips and Tricks
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    in my opinion it depends on your data, if your volume of data is small to medium and the model isn't too complex then it would probably be better to use Power BI. If the data model is large and more complex go with SSAS.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

     

yasbos's avatar
yasbos
Icon for Resolver II rankResolver II
3 years ago

Thanks, DOLEARY85 . I have large and complex data and access to SSAS, so I guess we shold/have to use only SSAS.

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Yeah, I would use SSAS then. Power BI is basically a lightweight verion of SSAS so it has it's benefits with small/medium datasets.

     

    It's usually the cost of SSAS i've found that's a sticking point for people using it so if you already have it and a large complex dataset i would certainly opt for that for the analytic side of creating models/measures etc