Would Direct Query keep updating that line graph in real time?

[JayneHatGuy]

So If there's a graph visual that shows the temp of a machine, we want to know when the temps spike up in real time so that the machine doesn't break .

Would Direct Query keep updating that line graph in real time? Can we set it up to be that way?

[Rayizer · Accepted solution]

Hi @JayneHatGuy, please refer to this article.  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

• If data is changing, it's necessary to refresh to ensure the latest data is shown: Given the use of caches, there's no guarantee that the visual is always showing the latest data. For example, a visual might show the transactions in the last day. Because of a slicer being changed, it might refresh to show the transactions for the last two days. The transactions could include recent, newly arrived transactions. Returning the slicer to its original value would result in it again showing the cached value previously obtained.

  Selecting Refresh clears any caches and refreshes all the visuals on the page to show the latest data.