I am new to powerBI and have a powerBI pro account, I would like to know how can I use the data present in Aurora RDS to create real-time dashboards in Power BI with a 30-sec refresh cadence. I thought of connecting the data to powerBI using MYSQL connector but just figured that MYSQL database connection in powerBI does not support directQuery. Can anyone advise? Thanks in advance.