SEP 2023 - Using Power BI with a Lot of Data by Paul Turley (@Paul_Turley)

Abstract
Can we use Power to deal with real-time data sources, very large tables, and transactional details? Yes, but it requires some planning and proper design. Out of the box, Power BI is super-fast with moderate data volumes and data schemas optimized for analytic reporting. How big is your data? Millions or billions of rows? Gigabytes or terabytes? - we can handle that. Moving beyond the basics, learn to use DirectQuery alongside in-memory Import mode in composite models to access very large tables with real-time results; models and reports that combine interactive "dashboard-style" reports and drill-through to transactional details. Take a journey and learn to use the Power BI platform to achieve the best of both worlds: performance and scale.

Session Materials
https://sqlserverbi.blog/wp-content/uploads/2023/01/Using-Power-BI-with-a-Lot-of-Data-2023-1.pdf
https://sqlserverbi.blog/wp-content/uploads/2023/01/PowerBILotsOfData_PTurley_Samples.zip

Speaker Bio
Paul is a Director & Competency Lead for 3Cloud Solutions, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter & user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox & Microsoft Press. Paul is a 2021 & 2022 FastTrack Recognized Solution Architect and holds several certifications related to the Microsoft Data Platform and Business Intelligence.