PowerBI access to S3/Athena

Question

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

Accepted Answer

Athena does support JDBC as mentioned [here][1] 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][2].

Power BI can connect to Athena using ODBC as mentioned [Power BI connect to Athena using ODBC 1][3] and [Power BI connect to Athena using ODBC 2][4].

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

[1]: https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
  [2]: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31356793-connector-amazon-s3-athena-with-power-bi
  [3]: https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers/athena-powerbi-odbc-mt-2768d3007996
  [4]: https://blog.openbridge.com/how-to-connect-microsoft-power-bi-to-amazon-athena-c2cc4f295ac4
  [5]: https://community.powerbi.com/t5/Integrations-with-Files-and/Can-I-connect-to-a-Amazon-S3-bucket-using-Power-Query/m-p/112364#M7645

PowerBI access to S3/Athena

Contenido relevante