Advanced Editor can be used to see the query that Power BI runs against data sources to import data.
- The query is written in M-code, the Power Query Formula Language
- To view the query code from Power BI Desktop, choose Edit Queries from the Home tab
- From either the Home or the View tab, click on Advanced Editor to work on the query. The Advanced Editor window opens, displaying the code for the currently selected query
- When we make transformations to our data in Query Editor, the steps are saved to the Applied Steps in the Query Settings
- These steps are also applied to the code in the Advanced Editor