Problem configuring AWS Athena Gateway Connection Driver

[jgbsantos]

Hi,

I have a problem that when trying to configure the AWS Athena Gateway connection. The configuration of the ODBC and CLI driver on the gateway server has been performed and is working.

But when you configure Power BI Online it doesn't work

[Anonymous]

Does the user with exactilly the username "powerbi" exist in your Athena instance? Double check this against the user in the ODBC connection in the gateway.

[jgbsantos]

This user exists, I made the registration via the CLI console.
The following image is for the direct connection test on the gateway server

[jgbsantos · Accepted solution]

Hello guys, The problem was solved. The problem was that I was not creating the Profile with the Gateway account on the server. It was necessary to login with the gateway user account so that the CLI could find the file with the profiles