Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. 

 

 

Analysis Service
PBI Report Server
  • andris's avatar
    andris
    7 years ago

    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

3 Replies

  • andris's avatar
    andris
    Resolver I
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

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

       

      • andris's avatar
        andris
        Resolver I
        7 years ago

        No. Those features don't need Analysis Services.