Amazon Athena ODBC Configuration in PBI Services

[wyoshida]

I need help to configure Amazon Athena ODBC in PBI Services and Gateway. 

I am using PowerBI Desktop Versão: 2.138.1203.0 64-bit (novembro de 2024).
My Local On-Premise Gateway is 3000.246.5 (Nov/24).

My Athena ODBC Connector is 2.00.01.01 (Although I tried v1.x as well).

My Power BI Desktop works fine retrieving data from Amazon S3 via Athena on my desktop. 

I Already read Amazon Athena connection with Power BI Service - Microsoft Fabric Community but I am stuck when creating the connection on PBI Service with a few errors which seems I don't really know what I am doing.

I went to "manage connections and gateway", selected "Local", selected my gateway, used the same connection name I am using on PBI Desktop, connection type "Amazon Athena", DSN used the same DSN configured on my windows desktop which is connecting fine to Athena.

Role. What am I supposed to fill in here? I tried getting the ARN from AWS for both role/RoleName and user/Username but they both fail with this message:

GW_YoshidaDesktop: ODBC: ERROR [HY000] Required connection parameter is missing: role_session_name ERROR [HY000] Required connection parameter is missing: role_session_name Tenha essas informações em mãos se você optar por criar um ticket de suporte. ID da sessão: 370bfeca-8511-47ae-aa8f-fdfc9da4cbf5 RequestId: 7f92dc4c-4bd8-429c-b576-c5e21db4e6ec URI do cluster: https://api.powerbi.com Código de status: 400 Hora: Tue Dec 10 2024 13:18:17 GMT-0300 (Horário Padrão de Brasília)

Also bellow in credentials I am being presented with 2 options which is anonymous and use AAD. 
When on PBI Desktop I use "use data source credentials" and used "IAM profile" as Auth Type in the ODBC conn.

My question is what should I put in role, and which option should I use for credentials as I have the secret key and access ID if needed, but I can't use AAD.

Also I know the best probable way to overcome this is to follow this is using AWS to host a machine (Creating dashboards quickly on Microsoft Power BI using Amazon Athena | AWS Big Data Blog)

But this is an NPO and we can't afford the cost.

[v-zhengdxu-msft · Accepted solution]

Hi @wyoshida 

Maybe you can try to use the Amazon S3 when select the Connection type:

Here are links for your reference:

Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AW...

Use the Amazon Athena Power BI connector - Amazon Athena

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.