Is connection from PowerBI to RDS SQL Server SSAS possible?

Question

I'm researching on connecting PowerBI to RDS SQL Server SSAS.

PowerBI state that it needs the user to have Server Administrator Role assigned:
https://learn.microsoft.com/en-us/analysis-services/instances/grant-server-admin-rights-to-an-analysis-services-instance?view=asallproducts-allversions

But RDS SQL Server SSAS feature says that it cannot do it:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSAS.html#SSAS.Limitations:~:text=Users%20aren%27t%20given%20SSAS%20server%20administrator%20access%2C%20but%20they%20can%20be%20granted%20database%2Dlevel%20administrator%20access.

Is there a workaround for those two to connect? Can Quicksight be used instead of PowerBI (There isn't much documentation)?

Answer

Can you pls share the link, where its stated that it needs Server Administrator role, so that we can understand the scenario bit more deeper to suggest possible options?. Assuming you are connecting through Data gateway and Gateway. Even a high level diagram of your setup will be good to understand the challenge precisely.

Is connection from PowerBI to RDS SQL Server SSAS possible?

相关内容