Blog: Update for Microsoft Azure Stream Analytics – IoT

Blog: Update for Microsoft Azure Stream Analytics – IoT

Last week Microsoft finally updated Microsoft Azure Stream Analytics with great new features. In this blogpost I explain some new features I use in our projects now.

Using custom code in your Microsoft Stream Analytics Query

In our projects we have sometimes challenges with the data we are receiving in Stream Analytics for the Microsoft Azure IoT Hub (finally the sensor off course…). For example we sometimes work with the Sigfox IoT network. With this network a device can sent small datapackages to the Azure IoT Hub, most of the times this is sent via a HEX format. Normally you want to transform this HEX data to a integer. (Yes, you can do it afterwards, but I want to do this directly in Stream Analytics query). One of the new functions just launched is support for Custom Code with JavaScript user defined functions. This is great, because I can great a function in Stream Analytics and transform my Hex to an INT just in the query. Here is how you do this:

  1. First of all you go to your Microsoft Stream Analytics job and select ‘Function’ and add a new one:
azuresafunction
Add a function in Azure Stream Analytics

2. After that you will get a window to create your javascript. In this example you see a hex to int function:

azuresaudf
Create UDF Javascript in Stream Analytics – Hex2Int sample

3. Now you can use your Javascript function in your query of Stream Analytics. Just type udf. than your function name and you can transform your HEX to an integer.

azuresausingfunction
Using UDF Javascript in your query of Stream Analytics

 

Visual Studio integration for Azure Stream Analytics

One challenge I have with creating queries in Azure Stream Analytics (yes, I am not the best with SQL..) is testing my queries with the data input. I was costing me a lot of time. I was the last weeks part of a private preview of the integration of Azure Stream Analytics in Visual Studio. That is now in public preview(download here). With this add-in you can export (or import) your Microsoft Stream Analytics projects in Visual Studio and test everything locally! Currently only Visual Studio 2015 is supported.

  1. First or all go to your Server Explorer and navigate to Stream Analytics and hit the export button.
vssaintegration
Export in Visual Studio a Stream Analytics project

2. Then your complete stream analytics project is exported to Visual Studio 2015. Here you get some great functionalities

vssaintegration2
Exported Azure Stream Analytics project in Visual Studio

Functionalities:

  • Syntax Highlighting in your queries
  • You can write your query and test it directly to testdata! Just hit F5!
  • You can write your custom Javascript code
  • You have off course directly integration with TFS / source control
vssaintegration3
Using local data to test your new queries

Low-latency dashboards in Power BI

Another new update is low latency support in your Microsoft Power BI output of Azure Stream Analytics. (Power BI streaming sets). The latency is now much better then some weeks ago. So you get faster insights in your data!

powerbilowlatency
Low latency in Power BI as output in Stream Analytics

Others

Other new functionalities:

  • Native support for Geospatial functions; now you can define geographical areas in your Azure Streaming job.
  • Job Diagnostics logs; there is now an integration with Azure Monitoring to better monitor your Stream Analytics Jobs!

 

 

 

 

 

 

Advertisements

New Windows 10 IoT Core insider build

New Windows 10 IoT Core insider build

Today Microsoft released a new build for Windows 10 IoT Core. Great new feature is that Cortana is enabled! Here the full list with new functionality / fixes:

New this build:

  • Cortana feature has been enabled.
  • The Dragonboard BSP in the provided FFU has been updated to the new build.
  • The Windows Device Portal (WDP/Web Management) has been extended to add a quick run portal for IoT Samples.
  • A fix was made to the Class Extensions for Hardware Notification (hwnclx) and USB Function (usbfnclx) packages so that they would be included in the default IoT Core images.
  • Changes were made to IoTShell to enable waiting for PPKG provisioned package installation to complete.
  • Updates were made to the GPIO Interrupt Buffer API.
  • Changes were made to Applyupdate.exe to add the blockrebooton/blockrebootoff flags.
  • A fix was made to the power state API to ensure the wakeup timer is cancelled upon exiting from connected standby.
  • Universal Write Filter (UWF) has been added as an option to the Windows Imaging and Configuration Designer (ICD).
  • The BluetoothLE stack has been updated to address the issues seen when calling GattDeviceService.GetCharacteristics.
  • Issues with NanoRDP connecting have been addressed.

Known Issues:

  • The package version for some inbox applications may not match the installed version.
  • Store applications are not being serviced when in use or set as the default application.
  • NanoRDP does not render correctly on some platforms.
  • When multiple audio devices are present on the board audio routing changes may not persist across boots.
  • The MinnowBoard Max firmware 0.93 has a known issue which can lead to network connectivity failure.

 

SmartBuildings factsheet

SmartBuildings factsheet

The last few months I wss busy with a SmartBuilding solution for some of our education clients to save square meters and give an app to studenten to find free rooms. Later I will create several post about the technical solution, but I have created (sorry its in dutch) white paper about this topic.

You can download it here from our website

Update for Microsoft Power BI on the iPhone

Update for Microsoft Power BI on the iPhone

I just received again an update for the Power BI on my iPhone. The following has changed:

  • I have huge problems with logging into Power BI with Azure AD. This is now solved
  • Preview: view and interact with optimized Power BI reports for the iPhone
  • Updated action bar for dashboards and tiles in focus mode
  • Finally 🙂 Breadcrumb navigation in tiles in focus mode

September update for Microsoft Power BI

September update for Microsoft Power BI

Microsoft just updated a news version for Microsoft Power BI with the following update:

Report View
ArcGIS Maps for Power BI (Preview)
Mobile report layout (Preview)
Updated drill behavior
Analytics

Forecasting (Preview)
Use your own R IDE

Data Connectors
Snowflake Connector DirectQuery Support
ProjectPlace Connector
Oracle Connector – Improved Navigator Previews Performance
OData Connector – Support for “Select Related Tables” option
SAP BW and SAP HANA Connectors – Enhancements to parameter input UX
Web Connector – UX Support for specifying HTTP Request Headers

Query Editing
Query Dependencies view
Show Errors experience
Query Editor Ribbon Support for Scalar Values
Add Function Invocation Column
Expand & Aggregate Columns – Support for “Load More” values
New Transform – Convert Table Column to a List
Keyboarding – Support for “smart typing” in dropdown menus

Here a video about the news features: