Tabular & Multimensioanl Modes in same SSAS Instance
Currently I have SQL Server 2014, and SSIS and SSAS Tabular, and about to upgrade to SQL Sever 2016.
Can I also have a SSAS Multidimensional instance in addition to my SSAS Tabular Mode instance? Can I have both, or what would the setup need to be?
I'd like to have a Multidimensional mode to run traditional SQL reports to bring into a cube to publish in the PBI Gateway, so users can end up doing all their reporting with PowerBI, and the cube model, whether Tabular or Multidimensional would be transparent.