cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
petermcnally Frequent Visitor
Frequent Visitor

streaming combine data

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

5 REPLIES 5
petermcnally Frequent Visitor
Frequent Visitor

streaming combine data

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

Super User
Super User

Re: streaming combine data

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Microsoft dkay84_PowerBI
Microsoft

Re: streaming combine data

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.

petermcnally Frequent Visitor
Frequent Visitor

Re: streaming combine data

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 Frequent Visitor
Frequent Visitor

Re: streaming combine data

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

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)