Redshift connection via Microsoft account needs Amazon resource name

Question

Dear team,

I am trying to connect to a redshift cluster using Power BI desktop and trying to sign in using Microsoft Azure AD as the service provider. When I do so, I get an error : 
"Using Microsoft account authentication requires an Amazon resource Name value for the role"

Power BI version : 2.96.1061.0 64-bit

Do you know what is the Amazon resource Name (ARN) that I need to input here? - Is this the cluster ARN for the redshift cluster that is expected here?

Regards,
Raunak

Answer

Hi

I think what you need to supply is an IAM Role ARN that has access to the Redshift Cluster.
Maybe this [aws blog post](https://aws.amazon.com/blogs/big-data/integrate-power-bi-with-amazon-redshift-for-insights-and-analytics/) can hel you with your setup.

Redshift connection via Microsoft account needs Amazon resource name

Contenido relevante