Christopher_Moo's avatar
Christopher_Moo
New Member
9 years ago
Status:
Completed

AWS Athena

Ability to connect to AWS Athena would be ideal. It is an excellent platform to manage large data while you are in the exploratory stages.

8 Comments

  • ye1's avatar
    ye1
    New Member
    Since Athena supports REST, could this not be developed through the custom connector framework ? Could not be much different than BigQuery which is supported (just).
  • OpenLink Software's Enterprise Edition ODBC-JDBC bridge enables Power BI to make connections to AWS Athena: <> .
  • Rather than go via the Enterprise Gateway or bridge driver, we need a direct query to Athena ... Amazon QuickSight and Tableau can do it: https://www.tableau.com/about/blog/2017/5/connect-your-s3-data-amazon-athena-connector-tableau-103-71105
  • annshmel's avatar
    annshmel
    Regular Visitor
    If anyone is looking to get started with Athena and connect it to Power BI via ODBC/JDBC, this may be of interest. Automated setup and optimization of data pipelines, including converting data to Apache Parquet format: https://blog.openbridge.com/aws-athena-automated-60-second-setup-zero-administration-and-automatic-optimization-eba474e9897a
  • '@Richard: PBI Gateway is only used in the context of hybrid connections between PBI online and on premises data sources (i.e. not for PaaS nor SaaS data sources) @Daniel: Interesting, but only relevant for connecting to Athena from PBI Desktop, so we're missing the most important part which is the ability to share these reports in PBI online @Yan: Most probably @MS: I would kindky urge you guys (as an ex-MSftee) to (re)prioritize the release and support of AWS data sources for PBI online if you don't want to loose new opportunities, as the Public Cloud is more and more becoming the place for (big) data to be hosted, and some tough competitors like Tableau and several others are supporting these for more than one year now (not to mention the newly released AWS QuickSight which is obviously supporting them all)
  • We need support to connect to Athena without ODBC driver. Also note VPC considerations in AWS.
  • An Amazon Athena connector has been announced for the July Power BI updates.

Recent ideas