In this example we intend to explore networks in Power BI. For this purpose we create a table with devices and their network interfaces, and three slicers to filter by reference location, network group, and device type. All of this is completed in five minutes.
First create a table that you populate with device name, type, vendor, model, and OS/Firmware from the Devices model. Certainly you can add all kinds of other fields from that model. To the same table you then add the fields from the Connections model that you are interested in. In our case this is IP address (L3 Address), MAC address (L2 Address), network address, and network group.
Note that you will most likely end up seeing multiple entries for one and the same device. That happens if a device has more than one network connection.
Now we add three slicers for Reference Location, Network Group, and device type. We have chosen to do the slicers for reference location and network group as drop-downs, and the slicer for device type as tile. Note that Reference Location and Type come from the Device model, whereas Network Group is taken from the Connections model.
It's easy to see how you can further extend this report with all sorts of additional functionality. For example, if we add another slicer for Network Type, which we take from the Connections model, we can easily filter for all kinds of fieldbus interfaces such as ControlNet or SERCOS that you may have in your data.
Comments
0 comments
Please sign in to leave a comment.