以下是步骤：

1. 从here

安装AWS CLI

2. 安装后，打开命令提示符并输入aws2 configure。输入用户的AWS Access和密钥。

3. 从here安装ODBC。

4. 将存储桶策略创建为JSON并将其附加到用户（将bucketname替换为具有要在Power BI上投影的数据的存储桶）

   {
       "Version": "2012-10-17","Statement": [
           {
               "Effect": "Allow","Action": [
                   "athena:BatchGetQueryExecution","athena:CancelQueryExecution","athena:GetCatalogs","athena:GetExecutionEngine","athena:GetExecutionEngines","athena:GetNamespace","athena:GetNamespaces","athena:GetQueryExecution","athena:GetQueryExecutions","athena:GetQueryResults","athena:GetTable","athena:GetTables","athena:ListQueryExecutions","athena:RunQuery","athena:StartQueryExecution","athena:StopQueryExecution"
               ],"Resource": [
                   "*"
               ]
           },{
               "Effect": "Allow","Action": [
                   "glue:CreateDatabase","glue:DeleteDatabase","glue:GetDatabase","glue:GetDatabases","glue:UpdateDatabase","glue:CreateTable","glue:DeleteTable","glue:BatchDeleteTable","glue:UpdateTable","glue:GetTable","glue:GetTables","glue:BatchCreatePartition","glue:CreatePartition","glue:DeletePartition","glue:BatchDeletePartition","glue:UpdatePartition","glue:GetPartition","glue:GetPartitions","glue:BatchGetPartition"
               ],"Action": [
                   "s3:GetBucketLocation","s3:GetObject","s3:ListBucket","s3:ListBucketMultipartUploads","s3:ListMultipartUploadParts","s3:AbortMultipartUpload","s3:CreateBucket","s3:PutObject"
               ],"Resource": [
                   "arn:aws:s3:::bucketname*"
               ]
           }
       ] }
   

5. 在同一区域中创建一个S3存储桶以供Power BI写入日志（在下面的示例中，其s3://athenanelogbucket。

6. 在“控制面板”->“管理员工具”->“ ODBC”->“添加”

   中的ODBC Athena simba连接器中输入以下内容

   

7. 将身份验证选项设置为默认凭据：

   

单击测试。如果成功，则继续使用powerbi

1. 并获取数据->搜索odbc->选择simba Athena odbc连接器->单击连接。

2. 它将询问用户名和密码，输入用户凭据。