Sónia Cruz

Microsoft Fabric provides powerful analytics and governance capabilities, but many of the most important insights — such as workspace metadata, refresh histories, which artifacts exist in your tenant and who has access to them — are only accessible through REST APIs. These include both non-admin APIs, which allow individual users to query their own artifacts, and admin APIs, which provide tenant-wide auditing and artifact visibility. By leveraging these APIs with Power Query, you can audit and gain clear visibility into your Fabric tenant, helping you stay organized and productive without writing custom code. In this session, you’ll learn how to use Power Query as a low-code API client to retrieve, shape, and analyze information from both non-admin and admin endpoints. Through practical demos and real-world examples, you’ll see how this approach empowers teams to maintain oversight of their Fabric artifacts, streamline governance, and build reusable datasets for reporting and auditing purposes.

Managing access and security in Power BI can quickly become complex, especially as your organization scales. Without a structured approach, teams risk inconsistent naming, overly permissive access, and governance challenges. In this session, I’ll share a practical framework for Power BI access management, built from my real-world experience. You’ll learn how to implement naming standards, workspace and dataset roles, Row-Level Security (RLS), and governance processes in a consistent and repeatable way. Through step-by-step examples and lessons learned, this session provides a repeatable method for auditing, organizing, and securing your Power BI environment, helping you maintain clarity, control, and productivity even in enterprise-scale deployments.