Forum Discussion

nairisha's avatar
nairisha
Advocate I
10 years ago
Solved

Live Dashboard Update as the data comes into the database

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 Analyti...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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).

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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).