Search code examples
amazon-s3powerbiaws-glueamazon-athena

How to load data into Power BI from S3 using an Athena query?

I've managed to load data into Power BI from S3 via Glue data catalogue using an ODBC connection.

However, I would like the data to be transformed by an Athena query before loading it into Power BI.

Is this possible and if so how?

Solution

  • Turned out I could just copy my Athena query and paste it in the SQL statement field under the advanced options when importing data using the ODBC connection:

    enter image description here