Solved: Problem configuring AWS Athena Gateway Connection ...

jgbsantos · ‎04-23-2020

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

jgbsantos · ‎10-09-2020

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

View solution in original post

Anonymous · ‎04-23-2020

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 · ‎04-24-2020

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 · ‎10-09-2020

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