AWS Redshift and PowerBi identity management

[amirdamirov]

Hi. I have a couple of questions related to Redshift and PowerBI.

I know that I can connect to Redshift through PowerBI using Redshift DB username and password.
But its there is a way to use AWS Iam users to connect to Redshift through PowerBI ?

Regards

[amirdamirov]

Yes, but in this case we use "Redshift Database" credentials. 
I mean username and password comes from Redshift itself not from AWS IAM users. 

[v-rzhou-msft]

Hi @amirdamirov ,

As far as I know, currently we can connect to Redshift DB by Amazon Redshift connector or ODBC connector. However, Power BI currently only support us to use Username and Password for authentication in both connectors.
For reference: 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-redshift

https://docs.devart.com/odbc/redshift/powerbi.htm

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.