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: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

monaraya
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