Forum Discussion

Rohitb's avatar
Rohitb
Icon for Helper I rankHelper I
2 years ago

On-Premise data Gateway connection to Azure Analysis Service

Hello All,

I am trying to create On-Premise data Gateway connection from Power BI service to Azure Analysis Service (AAS) as my AAS has firewall blockage, but the new connection box only shows Windows authentication option. Is there a way using which we can create connection using different authentication methods ?

 

 

Also, in the "Firewall" pane, the "Allow access from the Power BI Service" has been turned off.

 

 

 

4 Replies

  • according to docs AAS supports:

    - Entra cached

    - Entra uid and pwd in the connection string

    - Windows authentication (Integrated security) 

     

    I expect that configuration to allow you to pass to AAS the user is running the report based on AAS cubes.

    I think it should be ok since the pbi models should be live connected on AAS and the users running reports must have access to the cube that could leverage the security (OLS and RLS).

     

    Learn about connecting to Azure Analysis Services servers | Microsoft Learn

     

    which kind of authentication would you use instead?

     

     

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

    Hi Rohitb 

    AAS is a cloud service therefore no Gateway is needed for connection to it.

    Maybe turning On 

    can let you in.

     

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

      if you want to lock down your instance to only specified IPs you need to use a gateway.

      switching "allow access from the pbi" to on will allow all power bi service IPs on the firewall.

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

        Are you in Germany? Because I think this feature isn't supported in Germany.

        Also if you're looking to implement it for security reasons then use AD security groups and Power BI App for limited access