topic Re: SSAS Tabular Model and Multidimensional on same instance of SQL Server in Report Server

SSAS Tabular Model and Multidimensional on same instance of SQL Server

Anonymous — Fri, 21 May 2021 11:18:23 GMT

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

Re: SSAS Tabular Model and Multidimensional on same instance of SQL Server

blynchdata — Sat, 22 May 2021 14:13:47 GMT

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.

Re: SSAS Tabular Model and Multidimensional on same instance of SQL Server

d_gosbell — Sun, 23 May 2021 22:19:13 GMT

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")

Re: SSAS Tabular Model and Multidimensional on same instance of SQL Server

Anonymous — Tue, 25 May 2021 07:11:01 GMT

Thank you. That clarifies a lot.

Re: SSAS Tabular Model and Multidimensional on same instance of SQL Server

Anonymous — Tue, 25 May 2021 07:11:35 GMT

Why is it not ideal? Because of performance issuses, which are neccessary for running an instance?

Re: SSAS Tabular Model and Multidimensional on same instance of SQL Server

blynchdata — Thu, 27 May 2021 22:07:53 GMT

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.