I am monitoring a number of sensors which get polled via Modbus every second. This data goes straight to an SQL Database on AZURE.
The data is pulled into Power BI via partitioned table - 1 day is 'archived', 1 day in 'incremental' and real time is enabled.
Various Dax queries are used to return the most recent values as well as add some together to total various sensor data together.
However the reports are not refreshing as quick as I need - I need them to refresh every second for some data.
I am looking for someone who has specific experience with real time data in PowerBI to analyse my reports and DAX queries, and suggest improvements to make it real time.
Google Consol Users Application Release Category: AI Mobile App Development, Android, Android App Development, Android Studio, Mobile App Development Budget: ₹750 - ₹1250 INR