2
Answers

Streaming job analytics input and output not show in PowerBI

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.
  1. --Our criteria for fraud:  
  2. --Calls made from the same caller to two phone switches in different locations (for example, Australia and Europe) within five seconds
  3.   
  4. SELECT System.Timestamp AS WindowEnd, COUNT(*) AS eNtsaACT083(MyStream-Analytics-Job)  
  5. INTO "PBIOuput"(Output-Job-Stream).  
  6. FROM "PBIEventHub"(Input-Job-Stream) CS1 TIMESTAMP BY CallRecTime  
  7. JOIN "PBIEventHub" CS2 TIMESTAMP BY CallRecTime  
  8.   
  9. --Where the caller is the same, as indicated by IMSI (International Mobile Subscriber Identity)  
  10. ON CS1.CallingIMSI = CS2.CallingIMSI  
  11.   
  12. -- ...and date between CS1 and CS2 is between one and five seconds  
  13. AND DATEDIFF(ss, CS1, CS2) BETWEEN 1 AND 5  
  14.   
  15. -- Where the switch location is different  
  16. WHERE CS1.SwitchNum != CS2.SwitchNum  
  17. 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

Answers (2)