Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

Power BI Server Do you need Analysis Services to create DAX

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?


  • 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.

3 Replies

  • Salvador's avatar
    Salvador
    Icon for Responsive Resident rankResponsive Resident

    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.

    • DebbieE's avatar
      DebbieE
      Icon for Community Champion rankCommunity Champion

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

      • d_gosbell's avatar
        d_gosbell
        Icon for Super User rankSuper User

        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.