Blog Post

Power BI Community Blog
1 MIN READ

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

monaraya's avatar
monaraya
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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

Published 5 years ago
Version 1.0
how to
roundup
Support insights
tips & tricks
monaraya's avatar
Icon for Microsoft Employee rankMicrosoft Employee
Joined March 11, 2019
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.

4 Comments

  • fgsilva's avatar
    fgsilva
    New Member
    4 years ago

    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   [email protected]

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    jrpino59
    Frequent Visitor
    3 years ago

    Yo tambien tengo el mismo problema y no se como resolverlo