22-25 April 2026 
API Heroes: Auditing Your Fabric Tenant with Power Query
Proposed session for SQLBits 2026TL; DR
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.
Session Details
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 unlock the Power BI and Fabric REST APIs directly inside Fabric. Instead of writing custom applications, you’ll see how Power Query can retrieve, shape, and automate API-driven insights using familiar tools and patterns.
Through practical demos and real-world examples, we’ll explore how this approach helps teams succeed with Fabric by improving visibility, enabling governance, and supporting operational decision-making. You’ll learn how to call REST endpoints, handle authentication securely and transform API responses into reliable datasets that can be reused across your Fabric workloads.
This session focuses on real use cases, not theory — showing how Power Query and Fabric APIs can be combined to monitor your environment, support platform governance, and reduce manual effort, all while staying within the Microsoft Fabric ecosystem.
Whether you’re responsible for running Fabric at scale or simply want deeper insight into your environment, this session will give you practical techniques you can apply immediately.
In this session, you’ll learn how to use Power Query as a low-code API client to unlock the Power BI and Fabric REST APIs directly inside Fabric. Instead of writing custom applications, you’ll see how Power Query can retrieve, shape, and automate API-driven insights using familiar tools and patterns.
Through practical demos and real-world examples, we’ll explore how this approach helps teams succeed with Fabric by improving visibility, enabling governance, and supporting operational decision-making. You’ll learn how to call REST endpoints, handle authentication securely and transform API responses into reliable datasets that can be reused across your Fabric workloads.
This session focuses on real use cases, not theory — showing how Power Query and Fabric APIs can be combined to monitor your environment, support platform governance, and reduce manual effort, all while staying within the Microsoft Fabric ecosystem.
Whether you’re responsible for running Fabric at scale or simply want deeper insight into your environment, this session will give you practical techniques you can apply immediately.
3 things you'll get out of this session
By the end of this session, attendees will be able to:
Retrieve and audit Fabric artifacts using Power Query and both non-admin and admin REST APIs.
Handle authentication and transform API data securely and efficiently for tenant-level visibility.
Build reusable, low-code solutions to streamline governance and artifact auditing in Microsoft Fabric.
Speakers
Sónia Cruz's other proposed sessions for 2026
Power BI Security Playbook: A Framework for Naming, Access, Governance, and RLS - 2026