Forum Discussion
OLE DB or ODBC error [DataSource.Error] ODBC [HY000] [AmazonAthena] [S3ClientError]
Hello,
We are trying to connect Power BI Desktop to Athena using ODBC Driver version 2.0.2.2 (64-bit).
When we try to check tables, we see them in the catalog but, we can't preview data. We can select the table, but when we try to query something, Power BI send this error:
We have updated Power BI Desktop version, ODBC version to the last avaliable on AWS site. We have checked communications. We have opened ports 443 and 444.
Can someone give more ideas?
King Regards
2 Replies
- audreygerred
Super User
Hi! Have you confirmed that your network/firewall allows outbound connections to Amazon Athena and ensured that there are no traffic restrictions on SSL traffic? If you are using an ODBC driver make sure SSL options and you might want to check the option for "Use Trusted store".
We are using Athena ODBC Driver and we don't find "Use Trusted store" anywhere.
