Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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).
@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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.