Forum Discussion
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
- R1k91
Super User
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?
- R1k91
Super 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
Community 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