How to implement a live data visualisation in the fabric ecosystem?

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.

Thanks to MJParikh and tayloramy for your valuable inputs.