Establish a Live Connection or DirectQuery with Amazon Aurora (MySQL Compliant)

[puru85]

Hi Experts,

I am currently working with an Amazon Aurora (MySQL Compliant) database, and I need to establish a live connection or use DirectQuery with Power BI to ensure real-time data updates.

When attempting to connect using the MySQL Database connector in Power BI, I noticed there is no option for DirectQuery; it defaults to Import mode. This is problematic for my use case as I require up-to-date data without having to refresh the dataset manually.

Here are the details of my setup:

• Database: Amazon Aurora (MySQL Compliant)
• Tool: Power BI Desktop (latest version as of [current date])
• Goal: Establish a live connection or DirectQuery to ensure real-time data availability.
  
  

Any guidance or solutions to establish a live connection or DirectQuery with my Amazon Aurora database in Power BI would be greatly appreciated.

Thank you!

[puru85]

Hi @VijayP ,

Thank you for your suggestion. Unfortunately, I am unable to apply it, as both the Simba Trino connector and Denodo require a purchased license.

[VijayP · Accepted solution]

@puru85 

Using DirectQuery with Amazon Aurora (MySQL Compliant) in Power BI can be a bit tricky because, as of now, Power BI does not natively support DirectQuery for MySQL databases, including Amazon Aurora. However, you can use alternative methods to connect Power BI to Amazon Aurora and achieve similar functionality.

Methods to Connect Power BI to Amazon Aurora (MySQL Compliant)

1. Customer Connector - Tools like Simba MySQL ODBC Driver or custom connectors can be used, but they might not fully replicate DirectQuery capabilities.

2. Using a Middleware or Data Virtualization Layer

   You can use tools like Denodo, Dremio, or other data virtualization solutions to create a layer that supports DirectQuery. These tools can act as an intermediary, providing a compatible data source for Power BI.