The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to Solution.
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
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
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.