Query Editor allows greater control over the data, custom transformations, data type formatting, and many other options. Advanced Editor uses the Power Query Formula Language (or M) for scripting of the data query.