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:

 

Connect a Sigfox IoT device to the Microsoft Azure IoT Hub

Connect a Sigfox IoT device to  the Microsoft Azure IoT Hub

Since this week I have a Arduino Sigfox Snootlab IoT device connected to the ‘real’ Sigfox Backend system.(before I used an other backend system of Snootlab). With a device like this you can monitor anywhere in the Netherlands (IoT network) for example if a trashcan is full or not.

One of the reasons for doing this move to the Sigfox Backend system, is that I want to have an integration between the Sigfox IoT network and the Microsoft Azure IoT Hub. The Azure IoT Hub that we are using a lot in our IoT projects at Winvision. Since a couple of weeks Sigfox has a ‘connector’ to connect your IoT device to the Microsoft Azure IoT hub, and it’s really simple. In this small tutorial I will explain how it works.

First of all, if you are using the Akene board(like below) with Arduino, here you can find the library for the board.

Sigfox Akene Arduino board
Sigfox Akene Arduino board

First of all go to the Sigfox backend:

Here you see all your Sigfox connected devices. Click on the name to get the details of the device.

SigFoxDeviceListScreen1
Devicelist in Sigfox Backend

On the right top you can find a New button, where you can create a new callback to another system.

BackEndSigfoxDeviceDetailsScreen1

Select the Microsoft Azure IoT Hub

BackEndSigfoxDeviceDetailsIoTHub
Select Azure IoT Hub

After selecting the Microsoft Azure IoT hub you get in the screen where you only need to fill two configurations items(and that’s it!)

BackEndSigfoxDeviceDetailsIoTHubDetails
Configuration screen of the Microsoft Azure IoT Hub

You need to fill in the Connection string of your IoT Hub (you can find this in de Microsoft Azure Portal) I choose the iothubowner connection string.

After that you need a JSON body for receiving the right data (and you can use off course use your custom data)

{
“device” : “{device}”,
“data” : “{data}”,
“time” : {time},
“duplicate” : {duplicate},
“snr” : {snr},
“station” : “{station}”,
“avgSignal” : {avgSnr},
“lat” : {lat},
“lng” : {lng},
“rssi” : {rssi},
“seqNumber” : {seqNumber}
}

Click save and that’s it 🙂 !

Turn your Arduino device on and it will send the data to Sigfox and Sigfxo will send it to the Microsoft Azure IoT Hub.

To test if your data is received by the Azure IoT Hubyou can off course use Azure Stream Analytics with Microsoft Power BI. But for this post I just use the Iot-hub Explorer

With this tool you can see the messages that the Microsoft Azure IoT Hub is receiving in realtime.

Below you see the data of my device 77D3C on the Microsoft Azure IoT Hub. I have made the keys red. And it’s working!

iothubexplorer4
IoT Hub Explorer screen

Afer all Sigfox made it really SIMPLE to connect you Sigfox IoT device to the Microsoft Azure IoT Hub!

Power BI Nofication Center

Power BI Nofication Center

For Internet of Things projects I use a lot Microsoft Power BI to display the telemetry of sensors of predictions from Azure Machine Learning. One thing that was always difficult when I share (or somebody shared) a dashboard with somebody else, you didn’t get any notification in Microsoft Power BI. But that changed with the Power BI Notification Center. In the menu of Power BI you see a new icon with new and old notifications:

Microsoft Power BI Notification Center
Microsoft Power BI Notification Center

The great thing with Power BI that is available on all platforms (like iOS). The notifications are shown on all platforms! See below for a iPhone screenshot:

Microsoft Power BI Notifications on the iPhone
Microsoft Power BI Notifications on the iPhone

In the menu you will also see the history of all notifications. In the future more types of notifications will be available!

Windows 10 IoT TPM Security

Windows 10 IoT TPM Security

If you have IoT devices in the field, it’s really important to have good security on it. Not all hardware devices have for example a TPM chip (they are cheap). With Windows 10 IoT you can use this chip to have a safer device in the field. With Windows 10 IoT you have the following TPM ‘software’ options:

  • On chip
  • Firmware
  • Discrete (L2C or SPL)
  • TPM Simulator-dev tool

With TPM you can secure your IoT Device with the following options:

  • Malware Protection
    Secure boot mechanism and the possibility to enable remote attestation with ‘Measured Boot’
  • Protect data
    Bitlocker, the same as on your Windows 10 device you can use Bitlocker on your IoT device. With Bitlocker you can protect your data with strong encryption and secure key storage.
  • Resist tampering