topic streaming combine data in Developer

streaming combine data

petermcnally — Mon, 21 Nov 2016 15:22:03 GMT

Hello,

I have a streaming dataset that I am visualizing in a dashboard. The dataset is coming off sensors. I have a lookup table that conatains attribute information I would like to join to the streaming data so that I can see it in a visualization. E.g., it isnt't very user friendly to show temperature data for sensor 2e252ff136ebc358. I would like to say that is the Kitchen sensor instead.

How can I do this?

Thanks,

Peter

streaming combine data

petermcnally — Mon, 21 Nov 2016 15:17:55 GMT

Hello,

How can I do this?

Thanks,

Peter

Re: streaming combine data

Greg_Deckler — Mon, 21 Nov 2016 17:00:09 GMT

How are you streaming the data, via the REST API's? I would think that the "right" way to do this would be to pipe your telemetry data up to an Azure IoT Event Hub, connect the data to Azure Stream Analytics and then pipe the output to Power BI.

Re: streaming combine data

dkay84_PowerBI — Mon, 21 Nov 2016 17:53:58 GMT

Piggybacking off of @Greg_Deckler, I would want to know if you are using a Stream Analytics Job to query your Event Hub data and output it to Power BI. If so, you would likely need to do the lookup to rename your fields or records within your Stream Analytics query, and not at the Power BI side. I am not 100% sure of this, but that would be my first thought.

Re: streaming combine data

petermcnally — Wed, 14 Dec 2016 19:20:27 GMT

Thanks for the reply. I am simply following the tutorial that was posted here. My data is coming straight from a Raspberry Pi device into Power BI. I am not using Azure at all.

It is pretty cool to get it up and running, but I am experiencing a few issues. The Streaming API is in Preview, so that is to be expected. Do you know if there is a way to provide feedback to Preview features? Unfortunately the comments are closed for the blog posts related to the Streaming API.

Re: streaming combine data

Moh_ali_square — Sun, 25 Dec 2016 18:54:41 GMT

HI Peter, I am following the same example, but I got some errors while I am wokring in python, I have no experience with pyton.

I got below error

Traceback (most recent call last):
File "C:\Python27\powerbi-python-iot-client-master\uploadDHT22Data.py", line 8, in <module>
import Adafruit_DHT as dht
ImportError: No module named Adafruit_DHT

could you help to solve it.

thanks