Using Power BI with a Lot of Data! from Paul Turley

Can you use Power BI 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. But can it handle your data, if you have many Millions or Billions of rows? Gigabytes or terabytes of data? YES - With the right skills, Power BI can handle that.

Well known BI expert Paul Turley will move beyond the basics, showing the techniques necessary for using Power BI with large-scale data analytics. You'll see many demos as Paul demenstrates the best of both worlds: performance and scale.

You will learn:

• To use DirectQuery alongside In-Memory Import mode in composite models to access very large tables with real-time results
• To create models and reports that combine interactive "dashboard-style" reports and drill-through to transactional details

Paul Turley is a prominent speaker and blogger. His blog posts can be found at SQLServerBI.blog. He is a Principal Consultant for 3Cloud Solutions (formerly Pragmatic Works) and a 14 time Microsoft Data Platform MVP.