Forum Discussion
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.
I think to look deeper into the connectivity and how authentication is working from the Power BI desktop to the athena source and validate the M code before building the connector. You can follow this learning path to know more about how you can create custom connector and you will also find some sample M code here
https://learn.microsoft.com/en-us/power-query/creating-first-connector
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Is it possible to use IAM profile in connectors in power bi service? I tried using it with the athena connector but it is having some issues. I don't want to go the custom connector way if there is a possiblity of using iam profiles direclty with certified connectors.