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

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.