topic Re: PowerBI Report server and analysis service in Report Server

PowerBI Report server and analysis service

Anonymous — Mon, 24 Jun 2019 14:39:50 GMT

Hello,

Is there a need to install analysis service feature when deploying PowerBI Report server?

We are planning to deploy a seperate database instance and powerbi report server but i can't find out if we need to install the analysis service feature when installing the database instance.

I've hear this might be needed for direct query but can't really find out how this precisely works.

Re: PowerBI Report server and analysis service

andris — Tue, 25 Jun 2019 07:01:47 GMT

Hi.

Analysis Services are not mandatory, Power BI Report Server can run without Analysis Services.

Direct Query works on database tables too.

So, if you don't plan to use Analysis Services, you can run Report Server without them.

Regards

Andris

Re: PowerBI Report server and analysis service

Anonymous — Tue, 25 Jun 2019 12:27:52 GMT

Thus there is no need to have the analysis service feature for both scheduled refresh or direct query?

Re: PowerBI Report server and analysis service

andris — Wed, 26 Jun 2019 06:38:01 GMT

No. Those features don't need Analysis Services.