SQLBits 2023
Supercharge Power BI with Azure Synapse Analytics
In this session we will cover how to architect an end-to-end enterpise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.
Power BI is incredibly powerful at distributing and sharing data insights, through visualizations, across an entire organization. The democratization of Business Intelligence that Power BI brought with it is unparalleled. But Power BI on its own has its limitations and will often fall short, on its own, when designing end-to-end analytic platforms for enterprises. That’s where Synapse comes into the picture-for organizations, small and large, their current Power BI deployment can be supercharged with the capabilities of Azure Synapse.
In this session we will cover how to architect an end-to-end enterpise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.
After this session you will leave with a much better understanding of how Azure Synapse Analytics can supercharge your current Power BI.
In this session we will cover how to architect an end-to-end enterpise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.
After this session you will leave with a much better understanding of how Azure Synapse Analytics can supercharge your current Power BI.
Speakers
Mathias Halkjaer's other proposed sessions for 2026
Beware! SQL Injection through ADF/Pipelines - 2026
Fabric Data Agents and beyond - 2026
Ingesting API data with Python Notebooks - 2026
Mastering AI in Power BI - 2026
Mastering Direct Lake - 2026
Navigating Data Modeling in Direct Lake - 2026
The Future of Data - 2026
Vibecoding examples for data professionals - 2026
Vibe-coding for the data professional - 2026
When data lies - typical patterns for manipulating data - 2026
Mathias Halkjaer's previous sessions
Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
A deep dive into Direct Lake
The new Direct Lake storage mode in Power BI promises to revolutionize data handling by blending the real-time nature of DirectQuery and the high performance of Import mode. Is this all just hype, or does Direct Lake truly deliver on these claims?
Advanced Power BI refresh with ADF/Synapse
After this session, you will be able to conceptualize and implement different Power BI refresh scheduling patterns in ADF/Synapse. You’ll learn what limitations in Power BI you can overcome with an “external” orchestration tool as well as the different building blocks available. Finally, we will go through an example implementation as well as a step-by-step demo of how you can set this up yourself.
Supercharge Power BI with Azure Synapse Analytics
In this session we will cover how to architect an end-to-end enterpise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.