"Sales_Amount_Day", 'Sale'Īgainst a 1400-level model deployed to a SSAS 2017 Tabular instance, we get the following query captured in profiler: EVALUATE Next, I used a very simple Power BI report with a single visual (showing sales amount by day of month) and captured the DAX queries via profiler.Īgainst a 1103-level model deployed to a SSAS 2014 Tabular instance, we get the following query captured in profiler: EVALUATE To test this out, I installed SSAS 2014 Tabular & Multidimensional instances along side the existing SSAS 2017 Tabular & Multidimensional instances and deployed an equivalent SSAS database to each instance. Long story short: Not only does Power BI generate the same DAX queries regardless of the SSAS Multidimensional version… “Super DAX” is NOT supported by any version of Multidimensional instance. In other words, would Power BI generate “Super DAX” against 2016/2017 multidimensional instances? Can 2016/2017 multidimensional models even handle “Super DAX”? What I wasn’t sure of (and just finished testing) is whether or not the same was true for Multidimensional cubes. That benefit is “Super DAX” ( more info). For folks using Power BI reporting, there’s a pretty significant benefit in reporting against Tabular 1200+ models deployed to a SSAS 2016+ instance as opposed to a Tabular 1103 (and below) model deployed to a SSAS 2014 (and below) instance.
SSAS TABULAR VS MULTIDIMENSIONAL UPDATE
Update 20170825: some enhancements between SSAS MD 2014 to 2016/2016 worth mentioning… improved locking/blocking, memory allocation, heap fragmentation, database consistency checking (DBCC), and 圎vents GUI.Īs the meeting carried on, I started thinking a bit more about that question. That time and effort would be better spent migrating to Tabular 2016+”
My initial response was “ no, there would be little benefit in carrying out that upgrade… other than a few more years of support and a couple of random hotfixes. The client wanted to know if there was any benefit for them in upgrading from SSAS 2014 Multidimensional to SSAS 2016 Multidimensional. An interesting question came up during a recent engagement involving Power BI reporting against a Multidimensional data source.
0 kommentar(er)
