Live Dashboard Update as the data comes into the database

[nairisha]

I have a database hosted in AWS and would like to update my dashboard as the data comes into the database. Is there any away that you know of ? I have been able to do a test with Azure Stream Analytics but have not found a way to utilize the database in AWS.

If you know any way to handle the situation please let me know.

Thanks in advance.

[ankitpatira · Accepted solution]

@nairisha Power BI has directquery feature (live connection) for databases in sql server. I can see there are number of ideas posted here for AWS and you should vote for one to prioritise development in this area (assuming directquery will also be possible for aws databases). You can also consider option to use power bi rest apis in a custom app to push data in realtime to datasets in power bi and figure out a way to extract data from aws database in realtime (may be a trigger).