How to use Active Directory based authentication in Power BI Service to query data as per user's entitlements from AWS Athena

Asked Oct 05 '22 at 05:13

Active Oct 05 '22 at 07:56

Viewed 179 times

I have a requirement that user need to connect Power BI cloud Service to Athena (via on-premises datagateway) and fetch the data according to the user persona setup in AWS.

I understood from MS documentation that I need to have the above setup. On-premises Power BI gateway needs to be installed in Windows EC2 instance to route the calls from PowerBI cloud service to Athena.

My questions are

How can Athena understand the end user who is querying the data from Power BI cloud Service?
On-premises Power BI gateway uses the hard-coded fixed service account to query the data from Athena (using Athena Connector + ODBC) and proxy the user(and caches the data in on-premises gateway), is there any way to pass the user information to Athena, so Athena can authorize and serve the data, according to user's persona (like not showing PII data for the unauthorized users)

edited Oct 05 '22 at 07:56

marc_s

732,580
175
1,330
1,459

asked Oct 05 '22 at 05:13

Anandkumar

1,338
13
15

Were you able to solve this? – Luca Natali Aug 04 '23 at 15:40
was not able to resolve with Athena, had to use redshift and pass the user information to redshift to filter the data out – Anandkumar Aug 31 '23 at 15:32

How to use Active Directory based authentication in Power BI Service to query data as per user's entitlements from AWS Athena

0 Answers0