Forum Discussion
How to implement a live data visualisation in the fabric ecosystem?
- 1 year ago
Hi JordanAdam98 ,
Thanks for sharing your requirement in Microsoft Fabric Community.
As mentioned by MJParikh and tayloramy , the two main options in Fabric are either Power BI with Direct Lake/DirectQuery and automatic page refresh, or Real-Time Dashboards connected to KQL/Eventhouse for continuous updates.
Since your scenario sounds closer to a CRUD-style application where updates may only happen every few minutes or half an hour, using a Fabric Warehouse or Lakehouse as the data source with DirectQuery/Direct Lake and enabling auto page refresh in the report is usually the simplest approach. That way, the report can stay open on a screen and pull in changes without any manual refresh.
For Reference: Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn
If you need the visuals to update every few seconds instead of minutes, using Real-Time Dashboards would be the better option.
Please reach out for further assistance.
Thank you.
Hi JordanAdam98,
For Power BI, I believe that the page needs to be refreshed or the refresh button at the top right of the report needs to be clicked to refresh visuals if the semantic model changes while the report is open.
Have you considered using a realtime dashboard sitting on a KQL database? This will refresh in near real time.
Create a Real-Time Dashboard - Microsoft Fabric | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.