22-25 April 2026

Microsoft Fabric and the mess of SharePoint

Proposed session for SQLBits 2026

TL; DR

Access SharePoint lists and files from Fabric notebooks using secure authentication and robust patterns to load data into Lakehouse tables for reliable analytics and Power BI reporting.

Session Details

SharePoint is where lots of important but messy data lives; the lists and libraries that somehow run even the largest of companies. Microsoft Fabric provides great options to land that data in a lakehouse, but sometimes it isn't a quick click of the get data button. Using a notebook will mean you need to authenticate, which means an access token, secrets and service principals.
Using real world examples we will walk you through the complete pattern from start to finish of loading SharePoint data into a lakehouse ready to be part of your data strategy. Lots of demos and resources to take away with you.

3 things you'll get out of this session

Creating a service principal Using a reliable pattern to access SharePoint data Processing Excel workbooks

Speakers

Laura Graham-Brown

hatfullofdata.blog