Share via

Stream Analytics Job Failed - Query Compilation error (Incorrect Syntax?)

MS 21 Reputation points
2020-10-02T14:09:28.96+00:00

Hello,

I am having issues sending my MX Chip data from an IoT Hub > through Stream Analytics > into PowerBI

It appears that when I create an Input from the IoT hub, it confirms:
Testing Input, mxchip-bulk = Successful

When I create an output to PowerBI, it confirms:
Testing output, mxchip-powerbi-bulk = Successful

Pressing "Start" in Stream Analytics Overview tab caused "Your job has failed"
29788-2020-10-02-9-04-48.png

Not Totally sure what I am doing wrong here, but I can see data from the sensor coming in.
29895-2020-10-02-9-07-55.png

Azure IoT
Azure IoT
A category of Azure services for internet of things devices.
385 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,136 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
334 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MS 21 Reputation points
    2020-10-02T14:16:19.367+00:00

    It appears that I have solved my own problem - I needed to place Brackets " [ ] " around the Query items

    SELECT
    *
    INTO
    [mxchip-powerbi-bulk]
    FROM
    [mxchip-bulk]

    4 people found this answer helpful.