We also have the option of editing the code in the Advanced Editor, click Home -> Advanced Editor or View -> Advanced Editor (see the screenshot below). We can edit the code directly in the Formula Bar, we just need to provide the new file location as a text string. If the Formula Bar is not visible you can click View -> Formula Bar in the Power Query menu. The screenshot below shows the first step in the query with the M code displayed in the Formula Bar. Being first makes the M code easy to find as it’s always at the start □ Technically, it doesn’t have to be, and it doesn’t have to be called Source either. The first applied step in most queries is to identify the source data. Change the location in the query M code.How can you change the queries to point to the live source, rather than the test? In this post, we will answer this very question.Īs like most things in Excel, there are multiple ways to achieve this: You’ve built some queries in a test environment, and now it’s time to start using them for real.
0 Comments
Leave a Reply. |