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)?
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
Relevanter Inhalt
AWS OFFICIALAktualisiert vor 2 Jahren- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren