Hi Team
Can any mate help with the following sql query for consuming an output to my power bi desktop. I am unable to get an input and output both on my azure portal and power bi desktop dataset. What am missing? Kindly please assist as i sat with the problem close to a day now, i saw this example with fraudelence for using stream analytics job to connect to power bi dataset.
-
-
- SELECT System.Timestamp AS WindowEnd, COUNT(*) AS eNtsaACT083(MyStream-Analytics-Job)
- INTO "PBIOuput"(Output-Job-Stream).
- FROM "PBIEventHub"(Input-Job-Stream) CS1 TIMESTAMP BY CallRecTime
- JOIN "PBIEventHub" CS2 TIMESTAMP BY CallRecTime
-
-
- ON CS1.CallingIMSI = CS2.CallingIMSI
-
-
- AND DATEDIFF(ss, CS1, CS2) BETWEEN 1 AND 5
-
-
- WHERE CS1.SwitchNum != CS2.SwitchNum
- GROUP BY TumblingWindow(Duration(second, 1))
What am i missing had follow this link to that; Please help me team
https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/stream-analytics/stream-analytics-power-bi-dashboard.md