June 2024
Beginner to intermediate
484 pages
11h 56m
English
Content preview from Data Modeling with Microsoft Power BI
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 13. Understanding a Data Model from the Power Query Point of View
Power BI’s tool to create the tables for and maintain the shape of the data model is Power Query. Power Query is directly built into the product and can be accessed via Home → “Transform data.” It opens in a separate window, which is convenient if you have more than one screen. Then you can make changes to the transformations in Power Query, refresh the data model, and test in the reports without closing the Power Query window.
All changes you make in the UI in the Power Query window are “recorded” as steps, which are applied to the source data. You can re-access every step (which is convenient when you need to debug the transformations). For many of the steps, you can also click on the gear icon to change a step through a dialog box (which, in most cases, matches the dialog box you use when you create a step in the first place). Throughout Part IV, I also show how to directly change the steps or edit a script in the advanced editor. The language of the script is the Power Query mashup language, or M for short. Unfortunately, it doesn’t have much in common with the DAX language.
Power BI dataflows are sometimes called “Power Query online.” They share most of the functionality of Power Query. Unfortunately, they aren’t completely identical in terms of features, but so close that you can copy most M scripts between the two tools. Azure Data Factory offers a similar experience via Data Wrangling in Azure Data ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.