TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Guest User
Tech Writer
2.1k
472k
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.
--Our criteria for fraud:
--Calls made from the same caller to two phone switches in different locations (for example, Australia and Europe) within five seconds
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
--Where the caller is the same, as indicated by IMSI (International Mobile Subscriber Identity)
ON
CS1.CallingIMSI = CS2.CallingIMSI
-- ...and date between CS1 and CS2 is between one and five seconds
AND
DATEDIFF(ss, CS1, CS2)
BETWEEN
1
AND
5
-- Where the switch location is different
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
Reply
Answers (
2
)
How to create test cases for IOT devices/Mobile?
How to create date and time in azure sql database query?