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.
I recommend you try the following approach:
-
In Power BI there is an option to use a push url as data source. The concept is that data can be pushed into the Power BI dashboard via this url.
-
Then, in AWS use a service like for example AWS Lambda that will query the Aurora RDS every 30 seconds and invoke the Power BI push url.
3