© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
D. DingTransitioning to Microsoft Power Platformhttps://doi.org/10.1007/978-1-4842-9239-6_2

2. Power BI Core Components

David Ding1  
(1)
Sydney, NSW, Australia
 
This chapter uncovers the three key components of Power BI Desktop: Power Query, data models, and Data Analysis Express (DAX). Each component performs a critical aspect in the data analysis. Many reports developer overly focus on DAX and neglects the importance of Power Query and data models. This often results in overcomplicated and unpredictable DAX. This chapter explores the following.

  • Power Query for loading and transforming data tables

  • Data models for creating relationships between data tables

  • DAX ...

Get Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate 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