Auto refresh dashboard on Power Bi Web that publish from Power Bi Desktop

[liey87]

Hi, How to make dashboard on PowerBi Web that publish from PowerBi desktop refresh the screen at some interval? By mean interval is close time like seconds or minutes. Currently, all of the data is save to AzureSQL. In order to make attractive dashboard arrangement, we are using PowerBi Desktop to customize and publish to Web.

I have one Line graph and one card showing the latest value from SQL table by using "LastValue = MAX(DimValue[valueA])". On Web Dashboard, how to make it like Stream Analytics to PowerBi refresh? Which mean automatically get latest data and get live update. The value that been save to SQL is at every 3 seconds. On web, I need to click on Page header to go into report mode and click refresh then it will update the data.

Basically this will be not agree by client to show realtime data or at least latest data. It should be refresh at certain time to show the latest value from SQL. Any idea guys?

Edited: "LastValue = MAX(DimValue[valueA])" is a wrong information. I need to get MAX/LASTDATE of DateAndTime and show the valueA on the same row of it.

[MattAllington]

You have a few choices

1 manual refresh (this won't work for you)

2 schedule refresh (max 8 times per day)

3 real time feed with a REST API (this sounds like what you need). But it is not for beginners. 

Read about it here. https://powerbi.microsoft.com/en-us/blog/real-time-in-no-time-with-power-bi/

[liey87]

Hi, Do this options (APi streaming) can be customize in Power Bi? Because I want to put card on a page itself to show own value for each device. Let's say I have Power Meter, Temperature Controller. Each device will be put on main page to show its current value on a single card. This is require by Monitoring Services Team so that, they can monitor the current value from the devices. They don't accept average. Because every slight difference on real value matters since its monitoring the energy. Most I see on DAX or Power Bi desktop, more to Sales/Productions. So, I don't know what else we should do for this

[MattAllington]

Yes, it can be done. Power BI has no limits about what type of data it can display.  There are plenty of demos on the web. Here is one. https://www.youtube.com/watch?v=ORp9omvtjdY