DataSource.Error: ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWS

[JohnCYY238]

Hi all,

I am using the Power BI AWS Athena Connector with Simba Athena ODBC driver to import data in Power BI Desktop. 

At this stage, I have connected to the data source with the following message:

SUCCESS!

Successfully connected to data source!

ODBC Version: 03.80

Driver Version: 1.1.20.1003

Bitness: 64-bit

Locale: en_AU

However, when I viewed one of the tables within AwsDataCatalog, I get an following error message:

DataSource.Error: ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Error Message: HIVE_UNSUPPORTED_FORMAT: Unable to create input format

Then when I clicked on another file ending with ‘_csv’, I can see the list of data field names but with no data.

Our IT consultant is trying to work out whether it is permissions within the policy configuration that is needed, or is it on my side that some configuration is required.

Appreciate for any assistance.

[Divyesh_Khunt]

You will need to add this policy in your athena for the access key that you have received while logging in the ODBC ...... replace the arn with your arn

below is the code you can copy

{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"athena:StartQueryExecution",
"athena:GetQueryExecution",
"athena:GetQueryResults"
],
"Resource": "*"
}
]
}

[Anonymous]

Hi @JohnCYY238,

According to the error message, this issue seems more related to athena, you can try following options if helps:

1. The credentials are vailed and have permissions to access Athena.

2. The query syntax is correct.

3. The query is too complex and can be executed within the timeout limit.

4. Check the network connection status if it is stable enough and not dropping packets.

5. Check if the query if it hit any resource , concurrency, data size, query execution limits.

Regards,

Xiaoxin Sheng