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.
Youssef Youssef commented
We need support to connect to Athena without ODBC driver. Also note VPC considerations in AWS.
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:
Laurent Marzouk commented
@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)
Rather than go via the Enterprise Gateway or bridge driver, we need a direct query to Athena ... Amazon QuickSight and Tableau can do it:
Daniel Heward-Mills commented
OpenLink Software's Enterprise Edition ODBC-JDBC bridge enables Power BI to make connections to AWS Athena: <https://medium.com/openlink-odbc-jdbc-ado-net-data-access-drivers/athena-powerbi-odbc-mt-2768d3007996> .
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).