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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
iLikeAzureSQL
Helper I
Helper I

How can we build Live Charts?

My intention is to build a live chart, time series, to show customer activity realtime, like if a new order comes in then powerbi shows it up in dashboard, or something like aggregates of online sales for evey 1 min.

5 REPLIES 5

@iLikeAzureSQL The only method I am aware of that will automatically update the tile is Azure Stream Analytics. As ASA uses Power BI from that tool, and pipes in the information to the dashboard.

Using Live Connect to a SSAS instance or Direct Query doesn't automatically update the tiles when the backend is refreshed. They are on a ~15 minutes cycle. If you were to interact with the reports directly, you would see the changes, but it sounds like you are talking about a dashboard tile.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

I connect to a live stream analytics dataset, but my report is not refreshing by itself, I need to refresh manually.  Am I missing anything here?

@iLikeAzureSQL

Azure Stream Analytics (ASA) makes it easy to set up real-time analytic computations on data streaming from devices, sensors, web sites, applications and infrastructure systems. It supports a powerful high-level SQL-like language that dramatically simplifies the logic needed to visualize, alert, or act on incoming events in near real-time. Please refer to the link below.
https://powerbi.microsoft.com/en-us/blog/outputting-real-time-stream-analytics-data-to-a-power-bi-da...

 

Regards,

Charlie Liao

djnww
Impactful Individual
Impactful Individual

@iLikeAzureSQL,

 

If you're willing to wait for hourly updates (which is still fine in most cases as nobody will be staring at a screen 24/7), then just maintain/update the 'source' data in OneDrive. Power BI automatically refreshes hourly.

 

Cheers,

DJ

ankitpatira
Community Champion
Community Champion

@iLikeAzureSQL

There are few ways to do that.

1. Use power bi DirectQuery feature and connect live to data source that gets updated real time. As you interact with visuals in power bi data source is queried and you get live data.

2. Use Power bi REST Api to push data in real time to dataset in power bi service.

3. Use azure stream analytics with Power bi.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.