Showing results for 
Search instead for 
Did you mean: 
New Member

AWS Redshift and PowerBi identity management

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 ?


New Member

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

Community Support
Community Support

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:


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.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors