locked
Can Azure Streaming Analytics Jobs Send Every Event to Power BI From an Event Hub? RRS feed

  • Question

  • From what I can tell, I can only take aggregates of events every 1 second (at most). If more than 1 event occurs in that 1 second, I will not get a unique row for each event, but a single row for all events in that moment. I'd like to have details on every event that passes through my event hub. Can this be done? Please feel free to request clarification.
    • Edited by acecabana Monday, April 25, 2016 3:57 PM
    Monday, April 25, 2016 3:57 PM

Answers

  • Hi,

    There is absolutely no need to do temporal aggregations in Azure Stream Analytics (ASA). If you want you can do a straight pass-through query and use that as input to to whatever you want. Something like so:

    <<<<<<<<<<<<<<<<<<<<<<<<<<

    SELECT
        *
    INTO
        youroutput
    FROM
       yourinput

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>

    In the code above, "yourinput" is the source you have defined, and "youroutput" is the named source for the inout to PowerBI etc.

    Hope this helps.

    Niels


    http://www.nielsberglund.com | @nielsberglund

    Tuesday, April 26, 2016 4:02 AM
  • I'm glad your scenario is working.

    I just want to point out that Power BI does employ throughput constrains which may effect the ASA job and we therefore generally discourage "Select *" queries when outputting to Power BI. Guidance and possible implications of these constraints are described in the "Limitations and best practices"  section at https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-power-bi-dashboard/

    Thanks,
    Kati


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, May 4, 2016 5:03 PM

All replies

  • Hi,

    There is absolutely no need to do temporal aggregations in Azure Stream Analytics (ASA). If you want you can do a straight pass-through query and use that as input to to whatever you want. Something like so:

    <<<<<<<<<<<<<<<<<<<<<<<<<<

    SELECT
        *
    INTO
        youroutput
    FROM
       yourinput

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>

    In the code above, "yourinput" is the source you have defined, and "youroutput" is the named source for the inout to PowerBI etc.

    Hope this helps.

    Niels


    http://www.nielsberglund.com | @nielsberglund

    Tuesday, April 26, 2016 4:02 AM
  • Thanks for the reply. I do see this now and have implemented a query for real time data. Many thanks!
    Friday, April 29, 2016 3:39 PM
  • I'm glad your scenario is working.

    I just want to point out that Power BI does employ throughput constrains which may effect the ASA job and we therefore generally discourage "Select *" queries when outputting to Power BI. Guidance and possible implications of these constraints are described in the "Limitations and best practices"  section at https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-power-bi-dashboard/

    Thanks,
    Kati


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, May 4, 2016 5:03 PM