Forum Discussion
Gauge Widget - Real Time Value
- 10 years ago
To bypass the 8 updates limitation, why not use the DirectQuery mode? No schedule refresh is needed then.
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
How did you get around it. I like the idea is streaming the data, but auto summarise gives me incorrect visualisation.