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.
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
