Microsoft Fabric and the mess of SharePoint
Proposed session for SQLBits 2026TL; 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.
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's other proposed sessions for 2026
She-Ra and the Masters of the Dataverse - 2026
"Low Code, High Chaos: Taming the Shadow IT Beast" - 2026
Boost Power BI Productivity with TMDL Libraries - 2026
Centre of Excellence: Your Governance Superheroes Assemble! - 2026
Copilots, Chaos and Control: Getting Real About AI Productivity - 2026
Fabric Data Agents vs. Copilot Studio - 2026
Microsoft Fabric Activator and Power Automate - a great combination - 2026
Translytical Flows vs Embedding a Power App in your report - 2026
Why should we care about adoption? - 2026
Lewis Baybutt
lewisdoes.dev
Lewis Baybutt's other proposed sessions for 2026
Fabric Data Agents vs. Copilot Studio - 2026
Translytical Flows vs Embedding a Power App in your report - 2026