PowerBI real-time refresh capabilities.

akaranth · ‎08-10-2023

Hi Power BI team,

I'm looking for some guidance on using Power BI with near real-time refresh capabilities.
My team (part of CFS) has several dashboards with the background data changing often (Datasources are mostly Kusto tables and Azure SQL Database tables). However, I would like for the frontend dashboard to keep up as well.

Is there any particular package/upgrade option available? If so, what are the pricing options for Microsoft employees?

Thank you,

Ambika

danextian · ‎08-10-2023

Hi @akaranth ,

If your data source allows a direct query connection, you can have real-time data as you interact with the report. With direct query, data is not imported into the model but queried as you interact with the data. There are limitations to this approach though - some Power BI features are not supported in Direct Query mode.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Another way to have real-time report is the use of streaming datasets:

https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.