Forum Discussion
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 ?
Regards
2 Replies
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, but in this case we use "Redshift Database" credentials.
I mean username and password comes from Redshift itself not from AWS IAM users.
