OLE DB or ODBC error while connecting to Amazon Athena from Power BI Desktop using ODBC connector

[monaraya]

Issue: Connecting to Amazon Athena from Power BI Desktop using ODBC connector

Error: OLE DB or ODBC error:[DataSource.Error] ODBC: ERROR [HY000] [Simba][Athena] (1040)

Troubleshooting:

• From Power BI Desktop we use ODBC connector to connect to Amazon Athena datasource but to connect to Amazon Athena we have to install the driver related to it.
• Once the driver is installed, we have to recheck the advance options

• Click on the configure and click on advance options
  
• Uncheck the use Resultset Streaming box(By default it is checked)

• Once we click on Ok, we will be able to connect from Power BI Desktop

Author: Nithya Mallapu

Reviewer: Mounika Narayana Reddy

[fgsilva]

I had exactly the same isuue.  We applied the same palliative solution.  Any solution that solves this issue without lost of execution time. Francisco gomes   fr01.g.silva@gmail.com

[Anonymous]

Hi,

I faced a test error while adding the Athena ODBC driver to my windows ODBC DS administrator.

"FAILED!

[Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 14, Error Message: Invalid DNS Label found in URI host [Execution ID: ]"

This error is very annoying and I'm unable to find the root cause of this error anywhere. Please help if anyone knows how to resolve this problem.
In 'advanced options' I already lock/unlock the 'Use Resultset Streaming' option, but it doesn't work.

[jrpino59]

Yo tambien tengo el mismo problema y no se como resolverlo