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
Yes, but in this case we use "Redshift Database" credentials. I mean username and password comes from Redshift itself not from AWS IAM users.
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.