PowerBI real-time refresh capabilities.

[akaranth]

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]

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