PowerBI access to S3/Athena

0

Hi all,

My customer mentioned that they have been able to connect and secure Alteryx directly to S3 . Can they connect Power BI directly to S3 or thru Athena or via some other method in order to do similar reporting? I know this is possible via Redshift, but their various analytics requirements may not necessitate the use of a DW.

Thanks, Chris

AWS
Chris_S
asked 5 years ago763 views
1 Answer
0
Accepted Answer

Athena does support JDBC as mentioned here but I not sure if Power BI supports JDBC calls yet as this has been asked in their forums before with no answers No solutions for Power BI with JDBC to connect to S3 / Athena.

Power BI can connect to Athena using ODBC as mentioned Power BI connect to Athena using ODBC 1 and Power BI connect to Athena using ODBC 2.

You can also use Power Query to query data in S3 as mentioned Power Query with S3

AWS
Kunal_G
answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions