DataFlow connect to Athena (ODBC) Timed out

[catcollector]

When creating the dataflow, we're connecting to ODBC (where dsn is defined for Athena). We return out AWS Catalog from Athena. But, when I try to return a single table from Athena with just two rows and four columns, the operation timed out after around 10 minutes.

Here are the steps:

1. Create new dataflow
2. Define new tables > add new tables
3. Select ODBC as data source
4. On connection settings inpur the odbc connection string to bring up our athena connection, Next
5. ower Query screen displays with a list of Athena catalog, select a table from one of the database. The display/preview screen keeps spinning.  If I let this play out and wait for a preview, operation will time out here. But, we can select "Transform data" to proceed.
   
   
6. If I proceed past the preview screen and wait, the operation eventually times out
   
   
   Just curious whether anyone has pointers/advice here? I am able to query this table in AWS Athena.

[catcollector · Accepted solution]

This issue was resolved by adding a PORT 444 inbound rule to our security group in AWS.

https://aws.amazon.com/premiumsupport/knowledge-center/athena-connection-timeout-jdbc-odbc-driver/

[Anonymous]

Hi @catcollector ,

I am facing similar issue, my gateway and ODBC DSN is setup on an EC2 instance.

I tried opening ports for the EC2 instance but it did not work. Do we need to open the port 444 on the EC2 where the gateway is setup or is this something on the Athena end. 

[v-luwang-msft]

Hi @catcollector ,

Check the similar threads below:

https://community.powerbi.com/t5/Service/Dataflow-and-Athena-Initial-Refresh-Data-Load-is-slow/td-p/... 

And refer:

https://www.cdata.com/kb/tech/athena-powerbi-dataflows.rst

Best Regards,

Lu'ci'en