PowerBI Service Athena connector with AWS Profile not working

[jashukla]

Hello,

On EC2 instance, created Sys DSN where AWS Profile name is mentioned as authentication mode.

I'm able to publish the report (DirectQuery) from Desktop to Service using the Athena Connector (and selected default or config).

In the service, when i tried to create a Connection ( to be mapped with the data gateway), am facing below error. Appreciate your helo here:

Both desktop and gateway are installed on same ec2 instance. AWS profile tested with scripts so cred are good.

Connection Type: Athena

Auth method: Anonymous

Entered DSN Name and connection name

Error:

Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue

Details: scoring-gateway: ODBC: ERROR [08S01] [Simba][DriverIAMSupport] (8600) Connection Error: No AWS profile found: cb-bbscoring-nonprod-dev-cli Please have this information handy if you choose to create a support ticket. Session Id: fcf793f0-24f1-4007-b7ba-cb1f2ed25d3b RequestId: fb77fcc8-513f-460f-9314-5739d8399545 Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Apr 17 2024 20:54:47 GMT+0000 (Coordinated Universal Time)

[GilbertQ]

Hi @jashukla 

In order to connect with the Athena Connector, you need to have a username and password. Here is my bump post expanding how to successfully connect to Athena.

Did you know you can query data from AWS S3 into Power BI? - FourMoo | Fabric | Power BI

[jashukla]

Thanks for the response. Our DSN has to be AWS Profile-based (we're not allowed to hard code credentials there), therefore we are exploring how Athena connector can pull the username and password from the same AWS profile.

We intend to use the Athena views to generate the reports hence S3 may not be useful here.

Is there any way to extract the username and password from the AWS profile and supply to the Athena connector to map with the gateway?

Can we use the custom connector for this? If yes, could you share the power query code please (I'm very much new to this).

Thanks!