Tabular & Multimensioanl Modes in same SSAS Instance

[jpquinn]

Hello,

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.

Thanks,
JPQ

[Seth_C_Bauer · Accepted solution]

@jpquinn You can't set up the Instance to be both Tabular and MD. You have to choose one or the other. But you could set up multiple instances on the same machine, one for Tabular, one for MD.