Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

monaraya

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

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)

monaraya_0-1614263982446.png

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

monaraya_1-1614263982452.png

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

monaraya_3-1614263982459.png

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

 

Author: Nithya Mallapu

Reviewer: Mounika Narayana Reddy

Comments