Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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?
Solved! Go to Solution.
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:
Notice the Manage tab next to Home:
This auto-refresh button gives access to a dialog:
First, enable auto refresh.
Select the minimal time interval:
Then, select the default refresh rate:
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:
This is the experience from a user perspective.
--
Please like this message if it helped you. Thanks.
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.
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:
Notice the Manage tab next to Home:
This auto-refresh button gives access to a dialog:
First, enable auto refresh.
Select the minimal time interval:
Then, select the default refresh rate:
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:
This is the experience from a user perspective.
--
Please like this message if it helped you. Thanks.
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:
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:
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.
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:
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:
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:
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.
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?
You can find the description here: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/dashboard-real-time-create#enable-au...