Hybrid Tables in Power BI
Hybrid tables, a new addition to Power BI, are a game changer in that they provide the best of both worlds by allowing one table to have two storage modes at the same time!
Before the introduction of Hybrid tables, each table in Power BI could only have one storage mode: Import which loaded data entirely into Power BI’s memory or DirectQuery which left data in the back-end data source. When working with near real time requirements, Power BI developers had to use tables with DirectQuery; however, DirectQuery by itself could result in less than optimum query performance for large datasets and put a burden on the backend system.
Hybrid tables combine the two storage modes and therefore provide improved query performance for historical data by loading them into memory (Import) and provide near real time capability for recent data (DirectQuery).
Join this session to learn about different table storage modes in Power BI including the newest Hybrid option and how to use it.
Agenda:
- Introductions (5 mins)
- Presentation (55 mins)
- Q&A session (15 mins)
About Shabnam Watson:
Shabnam Watson is a Business Intelligence consultant and Microsoft Data Platform MVP with 20 years of experience developing Data Warehouse and Business Intelligence solutions. She has worked across several industries including Supply Chain, Finance, Retail, Insurance, and Health Care. Her areas of interest include Power BI, Analysis Services, Performance Tuning, PowerShell, DevOps, Azure, Natural Language Processing, and AI. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI.
She is a regular speaker and volunteer at national and local user groups and conferences. She holds a bachelor’s degree in Computer Engineering, a master’s degree in Computer Science, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI).
This event is online. You may need to install Zoom: https://zoom.us/download
Space is limited so reserve your seat.
Contact with Shabnam:
LinkedIn: https://www.linkedin.com/in/shabnamwatson/
www: https://shabnamwatson.wpcomstaging.com/
Twitter: @ShbWatson
Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.
Please log in or sign up to comment.