Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
bxstnk
Frequent Visitor

difference between real-time dashboard and Power BI report(dashboard)

What is the difference between a real-time dashboard and a Power BI report? How can they be differentiated effectively?

Can a real-time dashboard enable page auto-refresh?

1 ACCEPTED SOLUTION
svelde
New Member

Hello bxstnk,

I use Fabric Real-Time dashboards on top of my KQL Databases for insights based on timeseries data.

The Real-Time dashboards support auto refresh.

Once a dashboard is created, make sure you are in Editing mode:

svelde_0-1721210829185.png

Notice the Manage tab next to Home:

svelde_1-1721210864238.png

This auto-refresh button gives access to a dialog:

svelde_2-1721210919174.png

First, enable auto refresh.

Select the minimal time interval:

svelde_3-1721210976242.png

Then, select the default refresh rate:

svelde_4-1721211011866.png

 

Database editors can limit the minimum refresh rate that any viewer can set so as to reduce the cluster load.

 

Save the changes and start viewing the dashboard.

 

I set the default refresh rate to 5 minutes and the minimal time interval to 30 seconds:

svelde_5-1721211188206.png

This is the experience from a user perspective.

--

Please like this message if it helped you. Thanks.

 

 

 

View solution in original post

8 REPLIES 8
bxstnk
Frequent Visitor

I'm sorry.

I deleted my question.

Hi @bxstnk ,

Thanks for @svelde @JohanLudvig's replies!

@bxstnk Although Real-Time Intelligence can update data in near real time, it still has a delay of several seconds to several minutes, depending on the amount of data and the complexity of the transformation required.

And I see that you have already posted another thread for this question.
Reflecting Real-Time Data in Power BI - Microsoft Fabric Community
Generally speaking, one thread should only solve one problem. As @svelde  said, please separate the two questions. The original question of this thread has been solved. Please mark the reply you think is useful as solution so that more people facing the same problem can find the solution faster.
Regarding your second question, please continue to seek the answer in another thread. Thank you for your cooperation!

Best Regards,
Dino Tao

Hello bxstnk,

 

So you have data that is output every second.

 

KQL Databases are optimized for small batches and it needs some time to turn raw data into timeseries.

 

Can you see the data arriving every second in your KQL table if you rerun a query over and over again?

 

--

Please split up multiple questions so other with the same questions can find them from the main page. 

svelde
New Member

Hello bxstnk,

I use Fabric Real-Time dashboards on top of my KQL Databases for insights based on timeseries data.

The Real-Time dashboards support auto refresh.

Once a dashboard is created, make sure you are in Editing mode:

svelde_0-1721210829185.png

Notice the Manage tab next to Home:

svelde_1-1721210864238.png

This auto-refresh button gives access to a dialog:

svelde_2-1721210919174.png

First, enable auto refresh.

Select the minimal time interval:

svelde_3-1721210976242.png

Then, select the default refresh rate:

svelde_4-1721211011866.png

 

Database editors can limit the minimum refresh rate that any viewer can set so as to reduce the cluster load.

 

Save the changes and start viewing the dashboard.

 

I set the default refresh rate to 5 minutes and the minimal time interval to 30 seconds:

svelde_5-1721211188206.png

This is the experience from a user perspective.

--

Please like this message if it helped you. Thanks.

 

 

 

v-junyant-msft
Community Support
Community Support

Hi @bxstnk ,

First of all, they belong to different categories. power BI report (dashboard) belongs to the category of Power BI Service, and you only need to have a Power BI Free license to use most of its features.
The real-time dashboard is in the Fabric category, and you need at least a Fabric Trial Capacity to create it:

vjunyantmsft_0-1721178243187.png


The Power BI dashboard has two ways of pinning, the first is to pin a visual object to the dashboard individually, in which case the tiles are static; the second is to pin the entire report to the dashboard, in which case the tiles are dynamically changing.
Real Time dashboard can only pin a single visual object, and it is always dynamic.

Then again, they have different data sources. the Power BI dashboard's data source is determined by the report from which the tiles in the dashboard come, i.e., the same data source that Power BI supports.
Real Time dashboard is a product under Real Time Intelligence, so it only supports data sources supported by Real Time Intelligence:

vjunyantmsft_1-1721178639848.png


In addition, the functionality of the Power BI dashboard is different: the main purpose of the Power BI dashboard is to display data, reports, and sharing, and the only editing it can do is to add and remove tiles and modify the theme and layout of the dashboard.

vjunyantmsft_2-1721179005634.png

The Real Time dashboard can be used to modify and delete existing data sources, add new data sources, configure parameter (similar to the function of filter), set alarms (Data Activator), set automatic refresh, download the dashboard file and other functions:

vjunyantmsft_3-1721179432175.png

vjunyantmsft_4-1721179438595.png

You can also explore the data in the tile in more depth by clicking on the small table icon in the upper right corner of the dashboard:

vjunyantmsft_5-1721179513815.png

vjunyantmsft_6-1721179528164.png


One more thing is that they use different query languages; Power BI Dashboard uses DAX and Real Time Dashboard uses KQL.

For more information on how to set up an automatic refresh, follow the screenshot below:

vjunyantmsft_0-1721179821510.png

vjunyantmsft_1-1721179834935.png

 



Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JohanLudvig
Frequent Visitor

Power BI has never been really good at handling high-volume data streams (or streams in general in my opinion).

Real-Time dashboards are allready available in Azure Data Explorer - and if all you do is provide low latency real-time reporting for hands-on decision makers, this would be my preferred choice - despite Power BI also supporting KQL queries.

 

Use Real-Time dashboards for low-latency, high volume data streams on top of your single Kusto db.

Use Power BI for dashboards or reports with multiple sources, need for more complex transformations or customization.

 

real-time dashboard is not automatically refreshing the page even when the streaming data is updated. If you know of the page that explains how to set this up, could you please share me?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Top Solution Authors
Top Kudoed Authors