Forum Discussion
Advocate IMeasures in desktop vs in SSAS
Hi anandfarmers ,
It seems to be the difference between report level measure and normal measure, in terms of performance, there is no difference, it mainly depends on the size and complexity of the data. On the other hand, report-level measure values are created for live connections to Power BI datasets published in SSAS Tabular or Services. This means that the measure is available throughout the report, not just in the specific visualization in which it was created. As a result, the performance of report-level measure can be affected by network latency and data source performance.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Solution SageSharing two blog posts to help you with your questions. My preference would be to do as much as you can in SSAS tabular model.
Choosing to Model in Power BI vs SSAS Tabular (pragmaticworks.com)
Advocate IThanks amustafa.
Yes, having the measures in model is my optimal.
I am trying understand about performance impact of having measures in PBI vs in SSAS Tabular model.
- amustafa
Thank you for the Kudo anandfarmers
I have never benchmarked the performance between the two. I always give preference to scalibility and usability. My life is much easier if I have a good model in SSAS because users may ask to use other downstream applications and it saves me time then I have to worry about performance. I tweak the tabular model as much I can on source side 🙂