Error in getting data from amazon athena

[anmolmalviya05]

Hi Everyone, I'm trying to get data from amazon athena but getting below error,

Unable to establish connection with data source. Missing settings: {[AwsRegion]}

How to resolve this

[rajendraongole1 · Accepted solution]

Hi @anmolmalviya05 - you can check on the aws region eg: , region of your Amazon Athena instance. us_east1 or some other. make sure you are connecting to right instance. Ensure other settings, like Workgroup and S3 staging directory, are filled correctly.

Below ref links hope it helps:

Connecting Microsoft Power BI Desktop to AWS data sources - Using Microsoft Power BI with the AWS Cl...

What is Amazon Athena? - Amazon Athena