Stream Analytics Job Data Does Not Appear Under Streaming Datasets of PowerBi

[maydaymiao]

Hello All,

 I have a program that keeps sending data to Azure event hub and the format follows PowerBi streaming which is

"data = '[{{ "timestamp": "{0}", "temperature": "{1:0.1f}", "pressure": "{2:0.1f}" }}]'.format(now, temp, pressure)"

In Azure, there is a stream analytics job running, the input is event hub and output is blob storage & power bi. Below is the query,

SELECT 
timestamp, 
avg("temperature") as Temperature,
avg("pressure") as Pressure 
INTO
[henkelapacbi] 
FROM
[henkelapachub] 
GROUP BY
timestamp,
TUMBLINGWINDOW(second,5);

Just couple of weeks ago, the dataset can be automatically generated under streaming datasets of Power Bi, and in the dashbaord, I can click "Add tile", in real time data I can select that dataset and able to see the live time streaming in the line chart or gauge.

However, I stopped the streaming data for some days and today I started again, I found the dataset does not go to "streaming datasets" tab, which I cannot make real time data display in dashboard. Does anyone knows how to solve this problem?

[webermat]

I'm facing the same poblem. When I create the connection in stream analytics, the dataset is not going to be created in power bi. Does anyone has a solution for that?

[stathopi]

Any news on that? We are phasing the same issue...

[maydaymiao]

Not yet, the problem is just couple of weeks ago, it worked in streaming datasets. But now, it never went to there.

[v-qiuyu-msft · Accepted solution]

@maydaymiao @stathopi Please check this blog: Announcing Private Preview of Azure Stream Analytics Outputting to Power BI Streaming Datasets.

Best Regards,
Qiuyun Yu

[maydaymiao]

Hi Qiuyun, Thanks for the reply, I reviewed the blog you attached and I understand the process. However, the current issue from my side is the dataset does not generate under "Streaming Datasets" of Power Bi Embeded, but just generate as a normal dataset. But just a few weeks ago, it worked as streaming dataset.