Skip to content

Instantly share code, notes, and snippets.

@ChrisBriggsy
Created September 4, 2015 09:20
Show Gist options
  • Save ChrisBriggsy/c255adba341c2b2e8f3a to your computer and use it in GitHub Desktop.
Save ChrisBriggsy/c255adba341c2b2e8f3a to your computer and use it in GitHub Desktop.
How to connect Application Insights to Power BI via Azure Stream Analytic - Step 10 - Set the query
SELECT
flatEvent.ArrayValue.name,
count(flatEvent)
INTO
[SSWTimePro-Appinsights]
FROM
[export-input] A
OUTER APPLY GetElements(A.[event]) as flatEvent
GROUP BY TumblingWindow(minute, 1), flatEvent.ArrayValue.name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment