{"id":5622,"date":"2022-07-22T10:31:37","date_gmt":"2022-07-22T10:31:37","guid":{"rendered":"https:\/\/www.stl-training.co.uk\/b\/?p=5622"},"modified":"2023-12-30T23:04:09","modified_gmt":"2023-12-30T23:04:09","slug":"how-to-efficiently-cleanse-and-reshape-data-in-power-bi","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-efficiently-cleanse-and-reshape-data-in-power-bi\/","title":{"rendered":"How to Efficiently Cleanse and Reshape Data in Power BI"},"content":{"rendered":"

You can improve efficiency and accuracy when pulling and transforming data from various sources by using the Query Editor Tool in Power BI<\/a>. It\u2019s a marked improvement on using macros in Excel for this function. Read on to see why.<\/p>\n

Why use the Query Editor<\/strong><\/h2>\n

The Query Editor is where data sourced from a variety of locations can be transformed before loading data into Power BI Desktop<\/a> to create visuals. It works by making a connection back to the original data source so that whenever changes are made, they are saves as \u2018Applied Steps.\u2019 Importantly, they are stored in memory. Meaning that if source data is periodically changed or added to, then a simple refresh in Power BI desktop is all that is needed to update any report visuals based on that data. The process of cleansing and reshaping data can include:<\/p>\n