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]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb11.png "image[11]")
![image[12]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb12.png "image[12]")
![image[13]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb13.png "image[13]")
Clicked Edit Queries
![image[14]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb14.png "image[14]")
Did some scrubbing for similar values
![image[15]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb15.png "image[15]")
![image[16]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb16.png "image[16]")
Clicked Close and Apply
![image[17]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb17.png "image[17]")
Created a OS and Language slicer
![image[18]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb18.png "image[18]")
Clicked Publish, which pushes the report to Power BI Web
![image[19]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb19.png "image[19]")
Went to Web, Clicked “File -> Publish to Web”
![image[20]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb20.png "image[20]")
Copied the Embed code and pasted it into this page
![image[21]](/images/blog/azure-iot-certified-devices-power-bi_A7B4/image_thumb21.png "image[21]")
Jon