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

Sign in to queue

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