You're reading from Microsoft Power BI Performance Best Practices Learn practical techniques for building high-speed Power BI solutions

Product type Paperback

Published in Aug 2024

Publisher Packt

ISBN-13 9781835082256

Length 346 pages

Edition 2nd Edition

Languages

DAX

Tools

Azure

Concepts

Business Intelligence

Authors (2):

Thomas LeBlanc

Bhavik Merchant

View More author details

Table of Contents (23) Chapters

Preface

1. Part 1: Architecture, Bottlenecks, and Performance Targets FREE CHAPTER

2. Chapter 1: Setting Targets and Identifying Problem Areas

3. Chapter 2: Exploring Power BI Architecture and Configuration

4. Chapter 3: Learning the Tools for Performance Tuning

5. Part 2: Performance Analysis, Improvement, and Management

6. Chapter 4: Analyzing Logs and Metrics

7. Chapter 5: Optimization for Storage Modes

8. Chapter 6: Third-Party Utilities

9. Chapter 7: Performance Governance Framework

10. Part 3: Fetching, Transforming, and Visualizing Data

11. Chapter 8: Loading, Transforming, and Refreshing Data

12. Chapter 9: Report and Dashboard Design

13. Part 4: Data Models, Calculations, and Large Semantic Models

14. Chapter 10: Dimensional Modeling and Row Level Security

15. Chapter 11: Improving DAX

16. Chapter 12: High Scale Patterns

17. Part 5: Optimizing Capacities in Power BI Enterprises

18. Chapter 13: Working with Capacities

19. Chapter 14: Performance Needs for Fabric Artifacts

20. Chapter 15: Embedding in Web Apps

21. Index

Why subscribe?

22. Other Books You May Enjoy

Direct Lake semantic models

Microsoft Fabric introduced a new semantic model called Direct Lake. This semantic model is built in the Fabric (Power BI) service under a lakehouse or warehouse artifact. The warehouse structure is for those familiar with T-SQL and the lakehouse is for those developers using code such as Python in notebooks for ETL implementations. Both create and support what are called Delta tables. The best resource for understanding the properties of Delta tables is from Databricks: (https://docs.databricks.com/en/delta/index.html).

Using Delta tables in Fabric

Delta tables can be created and populated in Fabric or used in Fabric as a shortcut. Inside a warehouse or lakehouse, Delta tables can be linked to the Fabric artifact through a pointer in Fabric called a shortcut rather than to the files or table structure. Figure 5.10 shows the Delta Table and shortcut (two types), which have different icons.