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
Laura Graham-Brown's previous sessions
How to improve Q&A in Power BI
In this session we will go through a number of techniques to get closer to that natural language that Q&A visuals offer.
Making Dungeons and Dragons Accessible
Can we make the complex Dungeons and Dragons character sheet accessible using Power BI and low-code solutions? Lots of demos and banter between these speakers
Bringing Power BI into the Dataverse (and bringing Dataverse into Power BI)
Make the most of the data in Dataverse-based Microsoft Power Apps and Dynamics 365 with Power BI.
Gathering Report Requirements
How do we as report builders understand what our customers want and need in a report.
Power BI Charticulator
Come and learn this low-code tool to create your own visuals in Power BI
Power Query is taking over
This session will Power Query which is now a must for the keen citizen developer.
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