Forum Discussion
Power BI vs Data Warehouse
Hi All, I was reading this great community thread on the pros/cons of a data warehouse vs Power BI. http://community.powerbi.com/t5/Desktop/Power-Bi-vs-Data-Warehouse/m-p/78650#M32787 I...
Hi Matt,
I think there is plenty of life left in SSAS MDX and it has it's place. I see the data modelling engine as good for small to medium complex models. Tabular covers the middle ground nicely, but if a large complex model then I'd go MDX every time.
I'd like to see MS merge the two and offer a mixed mode data modelling environment in SSAS. Essentially the ability to create a single cube where you can chose Tabular/MDX per measure group.
Hi Phil_Seamark,
Yes, I mulled this over too. We have several MDX cubes and they're great! It just feels like the majority of Microsoft's new development is towards tabular. MDX has some great features that I can't wait for Tabular to adopt (and vice versa). :)