streaming combine data

[petermcnally]

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

[petermcnally]

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

[Greg_Deckler]

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.

[petermcnally]

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.  

[Moh_ali_square]

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

[dkay84_PowerBI]

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.