Christopher Mooney on 07 Mar 2017 01:15:43
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.
- Comments (6)
RE: AWS Athena
We need support to connect to Athena without ODBC driver. Also note VPC considerations in AWS.
RE: AWS Athena
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
RE: AWS Athena
'@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)
RE: 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
RE: AWS Athena
OpenLink Software's Enterprise Edition ODBC-JDBC bridge enables Power BI to make connections to AWS Athena: .
RE: AWS Athena
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).