ODBC Custom Connector- SAML profile

Hi SaiK ,

I get the hesitation with custom connectors. But unfortunately power BI Service does not natively support IAM profiles or roles (like EC2/ECS/EKS instance roles) when using certified connectors such as Amazon Athena.
It requires AWS access key and secret key authentication — even with the built-in Athena connector.
Power BI Service does not run in AWS environment, so it cannot assume an IAM role from metadata.

In Power BI Desktop, the Athena ODBC driver reads your ~/.aws/credentials file and environment variables. It can automatically use the saml profile because it's running locally and can execute your credential_process or run AWS CLI/SSO flows.
Hope this helps!

 If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.