Forum Discussion

Arez2017's avatar
Arez2017
Advocate I
8 years ago

PowerBi on promise - Distributed environment

Hello Community,　

I want to install PBI on promise in a distributed environment. So, I have installed:　

- SQL server on server1　

-SSAS Tabular on server2　

-PowerBI Report Server on server3　

When connecting to my dashboard I got this error attached.

 

I dont want to configure Kerberos.

Is there any workarround please?

Many thanks!　

distributed on promise server

4 Replies

  • muchinski's avatar
    muchinski
    Resolver II
    8 years ago

    Hi, if you don’t want to configure Kerberos delegation, you will not be able to use the "As the user viewing the report" option on the data source.
    To workaround this, just set a username and password on the connection of your reports. This user should be an AD user that have access to your SSAS database.

     

    • Arez2017's avatar
      Arez2017
      Advocate I
      8 years ago

      Hello

       

      Thanks for your reply. However, if I will set credentials, I will loose all security roles set on SSAS cube :(

       

      Regards

      • muchinski's avatar
        muchinski
        Resolver II
        8 years ago

        You can use an user who is Admin on SSAS and check the option "Log in using these credentials, but then try to impersonate the user viewing the report"

         

        This should keep all your roles working :)

         

         

        (just a personal feedback here: I prefer to use Kerberos delegation)