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)