For the most recent update on ongoing service disruptions affecting the AWS Middle East (UAE) Region (ME-CENTRAL-1), refer to the AWS Health Dashboard. For information on AWS Service migration, see How do I migrate my services to another region?
Is connection from PowerBI to RDS SQL Server SSAS possible?
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)?
- Language
- English
- Newest
- Most votes
- Most comments
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.
Relevant content
- asked 3 years ago
