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.
You should try to query it from athena, probably will get the same error. It's not a permissioning problem, but a data problem.