If you are using Microsoft Fabric or Power BI, you know that it can be hard to get an overview of what users are doing. If you haven´t got an explicit access to a workspace you don´t know what is in there. As a result, you are rather blind to what is going on in your tenant.

Microsoft brings some tools to the table. You have the Monitoring hub which will show you the execution history of some of the item types in Fabric. Then you have the Capacity Metrics App which will show you duration and resource consumption of fabric items.

But if your boss asks you questions like:
• How is the implementation going in department X
• What did employee Y access in the last 6 months
• Who is using Fabric?
• Are people creating the same lakehosue/semantic model/report etc. over and over

You won´t answer them except with a lot of work.

A way to be prepared for those questions is to build your own solution to monitor Fabric.

In this training day we will start from scratch and build the whole solution in one day. We will go through the requirements and then start building. We will talk about different ways of accessing the data, including using Fabric Data Factory and Spark. We will fetch data about all the items that exist in the tenant as well as metadata about them (owners, access etc.). On top of that we will fetch the data about who is using Fabric and what they are doing in the tenant.

We will use freely available community components to fast track our solution so that we don´t have to build everything from scratch.

Lastly, we will talk about how to model the data to make it ready for reporting.

This is a hands-on training day. The attendees are expected to build the solution together with the trainer.

Requirements:

To do the exercises the attendee can do one of two things. They can decide to create the monitoring in their own tenant, or they can create it in the training tenant. If they want to create it in their own tenant they need the following (detailed guidance will be sent before the training day):

• A Fabric capacity to work with
• A service principal in a Entra security group
• Specific settings turned on for the above Entra security group in the Fabric tenant

Or the user rights in Azure and the Fabric tenant to create these objects and set those settings.

If the attendee decides to use the training tenant of the instructor, they will leave with all the code and an easily transferrable solution to move to their tenant.

The attendees are expected to have at least an introductory knowledge of Data Factory and data engineering in general.

At the end of the day the attendee will have a complete solution to use in their tenant and be able to implement a DIY monitoring solution for the Fabric tenant.