Forum Discussion
Stream Analytics Job Data Does Not Appear Under Streaming Datasets of PowerBi
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?
maydaymiao stathopi Please check this blog: Announcing Private Preview of Azure Stream Analytics Outputting to Power BI Streaming Datasets.
Best Regards,
Qiuyun Yu
5 Replies
- stathopiNew Member
Any news on that? We are phasing the same issue...
- maydaymiaoFrequent Visitor
Not yet, the problem is just couple of weeks ago, it worked in streaming datasets. But now, it never went to there.
- v-qiuyu-msftCommunity Support
maydaymiao stathopi Please check this blog: Announcing Private Preview of Azure Stream Analytics Outputting to Power BI Streaming Datasets.
Best Regards,
Qiuyun Yu
- webermatNew Member
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?