topic Problem configuring AWS Athena Gateway Connection Driver in Developer

Problem configuring AWS Athena Gateway Connection Driver

jgbsantos — Thu, 23 Apr 2020 17:09:38 GMT

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

Re: Problem configuring AWS Athena Gateway Connection Driver

Anonymous — Thu, 23 Apr 2020 23:17:35 GMT

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.

Re: Problem configuring AWS Athena Gateway Connection Driver

jgbsantos — Fri, 24 Apr 2020 11:23:21 GMT

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

Re: Problem configuring AWS Athena Gateway Connection Driver

jgbsantos — Fri, 09 Oct 2020 17:31:00 GMT

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