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.

image[11]

image[12]
image[13]

Clicked Edit Queries

image[14]

Did some scrubbing for similar values

image[15]

image[16]

Clicked Close and Apply

image[17]

Created a OS and Language slicer

image[18]

Clicked Publish, which pushes the report to Power BI Web

image[19]

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

image[20]

Copied the Embed code and pasted it into this page

image[21]

Jon

Share