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.
