Gcobani Mkontwana

Gcobani Mkontwana

  • 568
  • 1.9k
  • 406.6k

Streaming job analytics input and output not show in PowerBI

Oct 10 2019 4:36 AM
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)