"Don't Summarize" option not available

[bgauvreau]

Hello,

I use Power BI SERVICE along with Azure Stream Analytics to make a real time dashboard. I use this Stream Analytics query to pass integer datas to my Power BI dashboard from Stream Analytics :

SELECT
    *
INTO
    [fan-monitoring-stream-analytics-output]
FROM
    [fan-monitoring-stream-analytics-input]

Only integer values are sent to Power BI Service by using this query. I would like to display these integer values in real time with the gauge control of Power BI but I'm unable to do so. The dataset only shows summurized values, not the real time one. The "don't Summarize" option is unavailable

Some persons seem to have solved this kind of problem by setting the dataset correctly in Power BI desktop. But I can't. I don't create the dataset in Power BI. It's created on the fly on Power BI Service by the Stream Analytics Azure service.

Does anyone have a clue that could help ? Your help will be very appreciated !

Bertrand

[v-qiuyu-msft · Accepted solution]

Hi @bgauvreau,

The Gauge visual is used for displaying a single value that measures progress toward a goal/KPI. Each field placed in the gauge will be aggregated and return a single value, and the measure also returns one value. So the "Don't summarize" feature is not supported in Gauge visual actually, whatever the data source is Azure Stream Analytics.

Best Regards,
Qiuyun Yu