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
- ye1New MemberSince Athena supports REST, could this not be developed through the custom connector framework ? Could not be much different than BigQuery which is supported (just).
- daniel_h_millsNew MemberOpenLink Software's Enterprise Edition ODBC-JDBC bridge enables Power BI to make connections to AWS Athena: <> . >
- richard_freema1New MemberRather 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
- annshmelRegular VisitorIf 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
- laurent_marzoukNew Member'@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)
- youssef_youssefNew MemberWe need support to connect to Athena without ODBC driver. Also note VPC considerations in AWS.
- nishalitNew Member
An Amazon Athena connector has been announced for the July Power BI updates.
- fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
extend storage capacity of varchar(8000) to varchar(max) for warehouse
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and st...c_mettler22 hours agoNew MemberCompleted3.3KViews61likes13CommentsAdjust column width in SQL Analytics Endpoint user interface
I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow. Also, the tooltip also doesn't show the entire...frithjof_v22 hours agoCommunity ChampionCompleted4.2KViews75likes8Comments