Explore the Azure IoT Certified Devices with Power BI

What do you do when you find a static table online that you want to quickly slice and dice? Enter Power BI. Here’s the resulting Power BI report…details on how I created it below…

• How this report was created…*

The Azure IoT Certified Device list is published by the Azure IoT team here: https://azure.microsoft.com/en-us/documentation/articles/iot-hub-tested-configurations/#certified-for-iot-devices

I used Power BI Desktop - Get Data -> Web Connector. Entered that URL and it presented me with all the tables on that page.

Clicked Edit Queries

Did some scrubbing for similar values

Clicked Close and Apply

Created a OS and Language slicer

Clicked Publish, which pushes the report to Power BI Web

Went to Web, Clicked “File -> Publish to Web”

Copied the Embed code and pasted it into this page

Jon