Skip to main content

Power BI

New

Amazon Aurora Connection

Vote (31) Share
Kawabata Yoshihiro's profile image

Kawabata Yoshihiro on 04 Aug 2016 05:05:23

I want to connect the databases on Amazon Aurora from Power BI Desktop, Power BI Services.

Comments (3)
Kawabata Yoshihiro's profile image Profile Picture

9aba3b1c 3c60-4a13-884c-a650c2bdeb09 on 05 Jul 2020 23:30:43

RE: Amazon Aurora Connection

This is an issue with PostgreSQL flavor of Aurora, not MySQL.

Kawabata Yoshihiro's profile image Profile Picture

b6e00bd4 0f67-49f9-b309-2ee4406124ab on 05 Jul 2020 22:54:08

RE: Amazon Aurora Connection

Please add a direct query to Amazon RDS / Aurora like you have for Redshift and SQL Server, otherwise you will need to use the Enterprise Gateway to sync the data on schedule. Almost all other BI Vendors have this.

Kawabata Yoshihiro's profile image Profile Picture

327b9bce a13a-47c2-a5f1-21a302412158 on 05 Jul 2020 22:48:04

RE: Amazon Aurora Connection

Have you tried the MySQL connector? It solved my problem with Aurora!