Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

monaraya
Microsoft Employee
‎02-25-2021 06:46 AM

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