© Dan Clark 2020
D. ClarkBeginning Microsoft Power BIhttps://doi.org/10.1007/978-1-4842-5620-6_15

15. Advanced Topics in Power BI Data Modeling

Dan Clark1 
(1)
Camp Hill, PA, USA
 

This chapter covers some advanced topics in Power BI data modeling that I think you may find useful. These are important for analyzing data over very large data sets. It includes direct queries, aggregation tables, and dataflow.

After completing this chapter, you will be able to

  • Determine when to use DirectQuery

  • Use aggregation tables

  • Use dataflows to populate a Common Data Model

Direct Queries

Throughout this book we have been importing the data into the Power BI tabular model. For most cases this is the preferred method for connecting to data sources and working with the data. ...

Get Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial