Part 1 of the video is for AWS Admin to set up the access for Power BI Developers. If you are a Power BI User, please jump to part 2 of the video 00:00 Intro 00:50 Break Down the Policy 05:23 Policy JSON 06:58 Live Demo in AWS Console 11:24 Advanced Topic Policy: ************************************Data************************************ { "Version": "2012-10-17", "Statement": [ { "Sid": "SourceBucketReadOnlyAccess", "Effect": "Allow", "Action": [ "s3:Get*", "s3:List*" ], "Resource": [ "arn:aws:s3::: *", "arn:aws:s3::: " ] } ] } ************************************Glue************************************ { "Version": "2012-10-17", "Statement": [ { "Sid": "GlueCatalog", "Effect": "Allow", "Action": [ "glue:Get*" ], "Resource": [ "arn:aws:glue:us-east-1:486152105877:catalog", "arn:aws:glue:us-east-1:486152105877:table/default/*", "arn:aws:glue:us-east-1:486152105877:database/default" ] } ] } **************************Athena************************************ { "Version": "2012-10-17", "Statement": [ { "Sid": "AthenaQueryExecution", "Effect": "Allow", "Action": [ "athena:StartQueryExecution", "athena:StopQueryExecution", "athena:GetQuery*" ], "Resource": "arn:aws:athena:us-east-1:486152105877:workgroup/primary" }, { "Sid": "AthenaResultBucket", "Effect": "Allow", "Action": [ "s3:PutObject*", "s3:Get*" ], "Resource": [ "arn:aws:s3:::tfsds-matthew-test", "arn:aws:s3:::tfsds-matthew-test/athena/*", "arn:aws:s3:::tfsds-matthew-test/athena" ] } ] }











