The Maker Show: Series - Particle Photon Weather Station Part 4 of 6 - Reporting with Power BI

Sign in to queue

Description

You can quickly access the other parts of the video series using these quick links:
<  pt.1  pt.2  pt.3  pt.4  pt.5  pt.6  > 

Particle Photon Weather Station - Part 4 of 6 - Reporting with Power BI

The overall goal of the series is to walk through using Particle Photon with a DHT11 sensor to publish data via a Particle Cloud Webhook to an Azure Event Hub.  We then look at consuming those messages with Stream Analytics and Power BI, as well as Node.js and .NET.

You can grab the slides and source code for this series at https://aka.ms/ppws

In this video we walk through:

[00:31] Overview
[03:47] Understanding Stream Analytics Inputs and Outputs
[05:59] Stream Analytics query overview
[07:53] Power BI sign up demo
[09:34] Stream Analytics job setup
[18:26] Power BI demo

Other videos in this series:

PPWS 01: Overview & Event Hub Setup
PPWS 02: Particle Cloud & Photon Prep
PPWS 03: Photon DHT11 Circuit, Webhook & Code
PPWS 04: Reporting with Power BI
PPWS 05: Receiving Events with Node.js
PPWS 06: Receiving Events with C#


Embed

Download

Download this episode

The Discussion

  • User profile image
    TheoIGetIt

    Outstanding series! I've been following along quite well but hit a snag in the Power BI segment. Despite defining value as a float, Power BI is insisting it's a string and will only perform COUNT on the field. 

    I tried starting/stopping the job, but it still thinks value (for temp and humidity) are string.

    If I export the data and open it in Excel, it's treats them as decimal, but that could just be Excel coercing the 'text' into numbers.

    Is there a way to check how/why a field defined as float would be treated as string? 

    Thanks so much for series - it's made clear a great deal about the various pieces of Azure.

  • User profile image
    BretStateham

    @TheoIGetIt:

    Thanks for your feed back. 

    I don't know of a way to see specifically the data type / conversion issue. 

    In your Stream Analytics Query, did you make sure to include the CREATE TABLE statement at the top?  You need to also ensure that the table name, matches the name of the input in your Stream Analytics query.

    If you had it wrong at first, and the data set was created in Power BI, you can delete the data set in Power BI.  After you do so, it should be re-created automatically the next time Stream Analytics tries to send the data into it.  You may need to delete your dashboard and report and start the visualization over again. 

    Let me know if that helps.

     

     

     

     

     

  • User profile image
    iwaldman

    Hi, great series.  Was having a little difficulty converting the client to send events in lieu of a real device i.e. device simulator, that loops say 1K times sending the temp and humidity data.  Would you happen to have some sample source code that does this?  Thanks again.

  • User profile image
    BretStateham

    @iwaldman:You can easily create a .NET client using C# using the sample code provided here https://aka.ms/echs.  That code walks through sending both a sender and a receiver. 

    Hopefully that will get you started.  Let me know if you need more help.

     

Add Your 2 Cents