Diving Into Graph API with Fabric Notebooks

Proposed session for SQLBits 2026

TL; DR

Microsoft Graph API is the unified gateway to Microsoft Cloud data, enabling powerful integration and automation. In this session, you’ll learn how to use Graph API with Microsoft Fabric to integrate SharePoint, analyze Power BI usage via Log Analytics, monitor Office 365 and OneDrive compliance, and interact with Azure services. We’ll cover core concepts, security best practices, and hands-on examples, plus provide ready-to-use GitHub templates so you can start building immediately. Join us to streamline cloud integrations and supercharge your Fabric workflows with Graph API.

Session Details

Microsoft Graph API serves as a unified gateway to access a wide range of data from Microsoft Cloud Services, unlocking powerful integration and automation opportunities.

In this session, we will explore key use cases, including:
• Integrating with SharePoint
• Leveraging Log Analytics for Power BI Usage
• Monitoring compliance in Office 365 and OneDrive
• Interfacing with Azure Portal and Services

Designed for those looking to get started with Graph API in Fabric, this session will cover essential concepts, security best practices, and practical examples. Attendees will also receive downloadable templates from GitHub, enabling them to quickly incorporate Graph API into their Fabric solutions and begin harnessing its full potential.

Join us to learn how to streamline your Microsoft Cloud integrations and optimize your Fabric workflows using Graph API.

3 things you'll get out of this session

1) Learn to Configure and Secure Graph API for Enterprise Automation 2) Apply Graph API to real-world scenarios, including SharePoint integration, Power BI usage analytics, and Office 365 compliance monitoring 3) Take Away Production Ready Templates

Bob Duffy's other proposed sessions for 2026

Automating Star Schemas in Fabric DW - 2026

PBI Financial Modelling Masterclass - Part 1 PL/BS - 2026

PBI Financial Modelling Masterclass – Part 2 AP/AR - 2026

RAG + Fabric + Eventhouse: An End-to-End Pattern for Automated Contract Compliance - 2026

Replacing ADF with Notebooks in Fabric - 2026

Bob Duffy's previous sessions

From SSIS to Synapse to Fabric - A Data Architects Case Study

In 2019 we migrated our EDW automation Framework to Synapse and ADF In 2023 we completed migration of the latest version to Fabric. This session shows you the - Migration process - Lessons learned - Improvements - Unit Test Strategy used. - What we are looking forward to Come along to hear some real-world lessons learned on using Fabric, Migrating to Fabric and re-architecting on Fabric using declarative techniques.

Financial Statements with Power BI - Part 1 P&L/BS

I will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet. included is PBIX so you can follow.

EDW Automation in Synapse SQL Pools

DW Automation and Design Best Practices

SQL Storage Fundamentals for Azure VMs

SQL Storage Fundamentals for Azure VMs

Financial Modelling with Power BI

Bob will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet.

The European Economic Crisis and the Euro-A Data Tale

Gain insights into what is behind the media storm surrounding the Economic Crisis, by diving into publically available data using PowerBI . Learn how the use of analytical tools can empower us by answering the questions we need to ask.

Scaling the DVD Store from 100 to a million TPM

Come along to see us attempt to optimise and redesign the “Dell DVD Store” sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.

When good SQL design goes bad

In this humorous session I’ll be contesting many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.

Migrating to the Cloud

In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and the demo performance, scalability and monitoring impacts.

Optimising Cube Processing

You don’t have to be an analysis services guru to gain a better understanding of how to analyse, configure and optimise cube processing.

The Irish Economic Crisis, Visualised with Power BI

In this session we will explore the Irish Economic Crisis from multiple perspectives, using Microsoft’s latest Visualisation tools including Power BI, Power Query, Power Map, Power View and Q&A.

SQL 2012 Always on Deep Dive

Always On Availability Groups offer a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in SQL 2012 emphasizing key features and benefits.

Windows Azure For SQL folk

We aim to cover the fundamental concepts that you should know on the Cloud and Windows Azure. In this demo based hour we will step through building Azure applications, deploying and managing them and what storage choices you will face.

SQL 2012 Always On-Deep Dive

Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits.

Load Testing Analysis Services

Ever deployed an Analysis Services cube that worked perfectly well with one user on the development server, only to find that it doesn’t meet the required volumes of user concurrency?

SQL Consolidation Planning

SQL Virtualisation using the Microsoft Assessment Planning tool and the SQL Consolidation Toolkit

SQL tuning from the dot.net perspective

So your customer's dot.net application is ready to ship and it is dog slow. This session focuses on the tools and methology that SQL consultants use to test and improve performance with dot.net applications.