topic Re: Power BI Server Do you need Analysis Services to create DAX in Report Server

Power BI Server Do you need Analysis Services to create DAX

DebbieE — Mon, 13 Jan 2020 11:57:11 GMT

I have been asked to look into report Server. I only have Service and I was wondering. To set up DAX do you need to connect report server up to Analysis Services? Or can youy create DAX in Report Server?

Re: Power BI Server Do you need Analysis Services to create DAX

Salvador — Mon, 13 Jan 2020 16:15:10 GMT

Hello,

If you have the service, you dont need to connect it to a SSAS, you can create a pbix, and upload it to the service.

Regards,

Salvador.

Re: Power BI Server Do you need Analysis Services to create DAX

DebbieE — Mon, 13 Jan 2020 16:18:21 GMT

I understand that about the Service. Do you need to set up and Analysis Service with Server?

Re: Power BI Server Do you need Analysis Services to create DAX

d_gosbell — Tue, 14 Jan 2020 05:13:16 GMT

DebbieE wrote:

I understand that about the Service. Do you need to set up and Analysis Service with Server?

No you don't.

Technically when you install Power BI Report Server it also installs a private instance of the tabular engine (SSAS) in order to host the pbix models. So you need to make sure your server has enough CPU and RAM capacity, but you don't need to do a separate install of SSAS.