Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

PowerBI Report server and analysis service

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. 

 

 

1 ACCEPTED SOLUTION
andris
Resolver I
Resolver I

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

View solution in original post

3 REPLIES 3
andris
Resolver I
Resolver I

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

Anonymous
Not applicable

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

 

No. Those features don't need Analysis Services.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.