© Mitchell Pearson, Brian Knight, Devin Knight, Manuel Quintana 2020
M. Pearson et al.Pro Microsoft Power Platformhttps://doi.org/10.1007/978-1-4842-6008-1_18

18. Defining Data Cleansing Business Rules with the Power Query Editor

Mitchell Pearson1 , Brian Knight2, Devin Knight2 and Manuel Quintana3
(1)
Fleming Island, FL, USA
(2)
Green Cove Springs, FL, USA
(3)
Jacksonville, FL, USA
 

As we saw in the previous chapter, there are many different connectors available within Power BI. Depending on what sources we are connecting to, we may run into data that needs to be cleaned up or transformed before building our reports. When this situation arises, we need to turn to the Power Query Editor to solve our data cleansing needs. In this chapter, we will take the ...

Get Pro Microsoft Power Platform: Solution Building for the Citizen Developer 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.