Opening the Advanced Editor

Power Queries collect the data from OpenGround.  The Advanced Editor in Power Query is used to modify the Queries.  

Follow the steps below to access the Advanced Editor.

• Click on the Transform Data icon on your Power BI Report
• Select the Query you want to edit on the Query list on the left-hand side of the Power Query Editor form.
• Click the Advanced Editor icon on the Power Query Editor toolbar.

(click on image to enlarge)