Using Microsoft Azure AD to access Amazon Redshift cluster in Power BI

[sarah-931]

Hello,

According to Amazon's documentation, I should be able to use Microsoft Azure AD as an identity provider to access my Amazon Redshift cluster. Everything works perfectly well on the desktop, and I am only seeing the data I am supposed to see for the user's authorization level. However, once I publish the report to the service and connect to the gateway, I can't see the data anymore. Has anyone been able to accomplish this, and if yes, can you please share how you did that?

Thanks a lot.
Sarah

[GilbertQ]

Hi @sarah-931 

As far as I am aware you would need to chat to your AWS Admin and ask them to configure and test it for you. once that is done you can then create the data source?

[sarah-931]

Hey @GilbertQ , we did that and they helped us to figure our things on the desktop but not the service. The pace is slow so wanted to find someone who was able to make it work and follow the steps for that ourseleves.

[GilbertQ]

Hi @sarah-931 

I unfortunately cannot assist you with this as I am not experienced in AWS.