Forum Discussion
Unable to create data source - AWS Athena
Hi,
I managed to connect AWS Athena to PBI Desktop successfully, as well as configure the on-premises gateway on VM.
When I used set the data source in PBI Service as ODBC, it was created successfully and allowed me to schedule refresh. When I've chosen data source type to be AWS Athena connector, now I get the following errors:
... when I choose OAuth2 authentication method and
... when selecting the Anonymous authentication method.
On the gateway, it was authenticated using IAM Credentials.
PS.
Yes, DSN is named the same as the one in the gateway
Hi, mba
Please first check that you have downloaded and installed the latest version of the PBI Desktop, gateway and Athena ODBC drivers. On the Authentication Method, it is recommended to choose Anonymous.
You can refer to the official AWS post, which provides a step-by-step guidance on how to use the Athena connector for Power BI to query, visualize, and share data with Power BI.
Creating dashboards quickly on Microsoft Power BI using Amazon Athena
Related thread:Connecting to Amazon Athena with ODBC
Best Regards,
Community Support Team _ Eason
3 Replies
Hi, mba
Please first check that you have downloaded and installed the latest version of the PBI Desktop, gateway and Athena ODBC drivers. On the Authentication Method, it is recommended to choose Anonymous.
You can refer to the official AWS post, which provides a step-by-step guidance on how to use the Athena connector for Power BI to query, visualize, and share data with Power BI.
Creating dashboards quickly on Microsoft Power BI using Amazon Athena
Related thread:Connecting to Amazon Athena with ODBC
Best Regards,
Community Support Team _ EasonWe are trying to connect to Amazon Athena using an On-premises Data Gateway, but we're unable to get it working.
On my local machine, I'm using the Amazon Athena ODBC driver with an AWS Access Key and Secret Key, and I'm able to build and refresh the report successfully in Power BI Desktop.
However, after publishing the report, I'm unable to establish the gateway connection for scheduled refresh. I've created the required System DSN on the gateway machine, but the connection still doesn't work.
Could you please guide me on what I might be missing or if there are any additional configuration steps required for the gateway to connect to Athena?
