In this story I'll share with you have to overcome reporting chaos and take control of the data through improved governance of Power BI - we'll use PBI REST API data to create a (meta)data warehouse and Power BI Reporting about Power BI. I invite you to join me on the journey of Power BI and Data transformation.

As in any story, there's no solution without a problem. At first glance, everything seemed in place: reports, measures, dimensions, users... even fancy AI! But beneath it all lurked a storm of issues the company faced: repetitive sales reports, lack of clear visibility on key metrics, chaos from the reporting layer to the data acquisition layer. The real challenge: how can you manage thousands of reports and the corresponding labirynth of the data layers if you don't know how they are used and by whom?

Here's where the real action begins! During this session, I'll present the ready-made solution to these challenges, along with the reflections and steps that led to success. I'll discuss not only the technical aspects of BI transformation, but also delve into the often overlooked human dimension: leadership and change management.

I'll show how measuring PBI consumption is key when it comes to rethinking your entire data strategy and steering the BI ship away from dire straits. I'll be your guide on a real data adventure, sharing the story that starts with messy Power BI (thousands of reports, AAS S9v2 Instances), uses APIs to seamlessly navigate among thousands of users, helps you sort out the needed map to the properly setup Lakehouse, and ends in the safe haven of the governed Power BI.

Finally, I will also share with you a real pirate map to the treasure trove of ROI calculations in the Power BI world.

Target audience: Power BI/Data navigators and BI ship captains: The session is a case study from a 2-year adventure. In it you will find anti-patterns occurring in the (Power) BI world and an experience-based way to solve them. Although the case uses a complex technical solution, I focus more on the approaches and delivered results than a deep technical dive. You won't find fancy DAX or Visual Building in my session: Adoption, Governance, User's Analytics and Change Management are the keywords.

Session Level: 400 - the case presented is advanced, you should have an understanding of how BI / CoE departments work, the differences between self-service and centrally produced data products, but also Power BI administration, governance, AAS, datawarehousing to get the most out of my session.

Notes:

The goal of my presentation is to leave participants with a very simple yet incredibly important takeaway: if you don't measure it, you can't manage it. My presentation will be a ready-made script showing how to focus on the latter—management.