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")
5 Replies
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")
It's not ideal, but we are doing it. We have one server that hosts both a Multidimensional instance and a Tabular instance.
This is to give us time to retire the old cubes and get Power BI Tabular Models in the hands of our stakeholders sooner rather than later.
Yes. 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.
