title: Credentials for AWS Athena ODBC connection
body: <p>I want to access AWS Athena in Power BI with ODBC. I used the ODBC driver(1.0.3) that Amazon provides:
  <a href="https://docs.aws.amazon.com/de_de/athena/latest/ug/connect-with-odbc.html" rel="nofollow noreferrer">https://docs.aws.amazon.com/de_de/athena/latest/ug/connect-with-odbc.html</a>
  To access the AWS-Service I use the user=YYY and the password=XXX. To access the relevant data our administrator created a role “ExternalAthenaAccessRole@99999”.
  99999 is the ID of the account where Athena runs.</p>
  
  <p>To use the ODVC-driver in Power BI I created the following connection string:</p>
  
  <pre><code>Driver=Simba Athena ODBC Driver;AwsRegion=eu-central-1;S3OutputLocation=s3://query-results-bucket/testfolder;AuthenticationType=IAM Credentials;
  </code></pre>
  
  <p>But when I enter the User XXX with the password YYY It get the message “We couldn’t authenticate with the credentials provided. Please try again.”.</p>
  
  <p>Normally I would think that I must include the role “ExternalAthenaAccessRole@99999” in the connection string, but I couldn’t find a parameter for it in the documentation.
  <a href="https://s3.amazonaws.com/athena-downloads/drivers/ODBC/SimbaAthenaODBC_1.0.3/Simba+Athena+ODBC+Install+and+Configuration+Guide.pdf" rel="nofollow noreferrer">https://s3.amazonaws.com/athena-downloads/drivers/ODBC/SimbaAthenaODBC_1.0.3/Simba+Athena+ODBC+Install+and+Configuration+Guide.pdf</a></p>
  
  <p>Can anybody help me how I can change the connection string so that I can access the data with the ODBC driver in Power BI?</p>