Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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/
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/
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.
Hi @catcollector ,
Check the similar threads below:
And refer:
https://www.cdata.com/kb/tech/athena-powerbi-dataflows.rst
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.