Forum Discussion
SSAS Tabular Model and Multidimensional on same instance of SQL Server
Hi, is it possible to configure both sorts of model on the same SQl Server instance to let Power BI run on both model types? kind regards
Just to clarify - you cannot run both types of models in a single instance, but you could install 2 different named instances on one server and have one in Tabular mode and one in Multidimensional mode. So you would connect to somthing like either server1\tabular or server1\multidimensional (assuming you had named the instances "tabular" and "multidimensional")
Why is it not ideal? Because of performance issuses, which are neccessary for running an instance?
blynchdata
Resolver I
Resolver IYes. For me it's not ideal supporting two different technologies, one of which seems to not be getting active development and then like you said performance. The way they share and use RAM and the other resources is confusing to me and probably strains our server.