When you use Power Query to retrieve data often need to be “purified” before they can continue to be used in the reports. For this purpose you can use a tool called Query Editor. It opens in a separate window, just like Data model, with its own ribbon menus that have a multitude of options for data processing. The following text will be talking about some basic options that allow transformation of data.