Input data from multiple sources Azure streaming job

Question

I need to send data from two devices to my Azure IOT hub. Both of the devices transmit data with different JSON format. The common column between them is TimeStamp.

Now i need to consume and combine these two inputs and output my data into Power BI. Can anybody suggest any approach or any link to refer to?

Prateek Raina

This question is too vague at the moment and is likely to be closed. I suggest editing your question and adding a little sample of your data (anonymised if you like), describe the story you would like to tell, and ask specific questions - what exactly you have problems with. — user5226582, Jun 07 '17 at 13:05

score 0 · Answer 1 · answered Jun 07 '17 at 18:57

To implement such a scenario you might want to use Azure Stream Analytics to reconcile the 2 different data types. The query language for ASA is SQL like and is pretty straight forward, it shouldn't be too hard to do this considering your data sources are both json. Note that you can easily setup PowerBI as the output for Stream Analytics as well.

score 0 · Answer 2 · answered Jun 20 '17 at 13:43

0

I suggest you send it separately. But if you want to achieve with a single datatable, you can join it with Union.

answered Jun 20 '17 at 13:43

Kartal Cakmak

25
3

Input data from multiple sources Azure streaming job

2 Answers2