Reflecting Real-Time Data in Power BI or real time dashboard

[bxstnk]

Hello, everyone.

I am importing real-time data from Azure IoT Hub (at 1-second intervals) and writing it to a table in a KQL database. In that table, I extract the latest 100 entries by KQL query and have created a line chart report in Power BI using this data. In Power BI, I have enabled page auto-refresh and set the refresh interval to 1 second. However, in the Power BI report, the data does not reflect on the chart every second but rather every 20-30 seconds in batches. Is it possible to reflect the data on chart every second?

I also wonder about reflecting data on the real-time dashboard chart.

My data is output every second. However, the data is not reflected for the line chart on the screen every second, but instead, it appears on the chart every 20-30 seconds.

 

Would it be possible to shorten the interval of reflecting on the dashboard screen chart? For example, 1 second or a few seconds.

I have set autorefresh to enable, and additionally set the minimum time interval and refresh rate to 1 second.

 

thank you.

[svelde]

As seen here, when working with (event) streams, at least 4 capacity units (F4) is recommended. 

By increasing the number of units, more 'compute' is available for streaming logic. It can take a short time for the capacity to adjust this.

How many capacity units are you having right now?

If needed, can you switch over to F8 or F16, for a day or so (billing is only adjusted for that time period)?

[bxstnk]

thank you.

I'm using trial capacity.

I understand the trial capacity has 64 capacity units.

https://learn.microsoft.com/en-us/fabric/get-started/fabric-trial

[bxstnk]

how can I enable a streaming policy?

could you please share the instruction page of microsoft? I'm sorry but I couldn't find it.

[JohanLudvig · Accepted solution]

You can find both the .alter table and .alter database here: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/streaming-ingestion-policy

Use the navigation tree on the left for each option.

If the streaming policy isn't enabled on the table or database you will typically experience a lag where the engine bundles together a certain number of rows before it inserts to the table.

[JohanLudvig]

Have you enabled a streaming policy on the table or the database?