Forum Discussion

bgauvreau's avatar
bgauvreau
Advocate I
10 years ago
Solved

Gauge Widget - Real Time Value

Hi,   I want to display a real time value in a gauge widget for an operational dashboard. But when I select the value to be displayed in the widget, I only have access to summurized values. There i...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    bgauvreau

     

    To bypass the 8 updates limitation, why not use the DirectQuery mode? No schedule refresh is needed then.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

bgauvreau

 

So you're talking about something on Power BI mobile, while I don't really know much.

Regarding the Gauge Widget and "latest", you can reference a measure as below.

 

Measure =
AVERAGEX (
    FILTER ( ALL ( 'Table' ), 'Table'[datetime] = MAX ( 'Table'[datetime] ) ),
    'Table'[temperature ]
)

 

bgauvreau's avatar
bgauvreau
Advocate I
10 years ago

Hi Eric,

 

Thank you for the idea.

 

A measure would certainly do the job If I would use the desktop application. But I found out that If I create my reports with Power BI Desktop and then transfer them to Power BI Service I'm limited to 8 updates per day, even with the Pro version.

 

That's why I try to send datas directly from Azure Stream Analytics to Power BI Service. But by doing it this way, I can't neither create any measure nor do any data manipulation after the datas are sent to Power BI.

 

I worked a lot to create an appropriate T-SQL query in Azure Stream Analytics before the datas are transfered to Power BI. This way I thought that I would be able to avoir aggregation but it failed...

 

Power BI is more and more used to display datas of iot projects. All the documentation (Microsoft and other) recommends to transfer datas directly from Stream Analytics to Power BI to build a serious Azure based iot project. So I can't believe that it's impossible to display real-time iot datas with Power BI Service gauges. There must be a way to do it ! If not, I think that this feature should be added to Power BI as soon as possible.

 

Whould you have any kind of "Super Incredible trick" that would make my "Dream" come true ? 😉

 

Thanks

 

Bertrand

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    bgauvreau

     

    To bypass the 8 updates limitation, why not use the DirectQuery mode? No schedule refresh is needed then.

  • Jpadda's avatar
    Jpadda
    Regular Visitor
    8 years ago
    Hi Bertrand, I am having the exact same issue us as you. Auto Summarize is poor, especially if you can't remove it... As in the case of Stream Analytics data.
    How did you get around it. I like the idea is streaming the data, but auto summarise gives me incorrect visualisation.