However, there is a crucial difference rather than changing the source for one single query, it changes the source for all the queries using that as the source. This will bring up the same window as clicking the gear icon (as we saw earlier). In the Data Source settings window, select the source we want to change, then click the Change Source. In the Power Query editor click Home -> Data Source settings

In fact, this may be a better way in general. Where there are multiple queries all coming from the same source, there is a better way to repoint to the source data the Data Source settings. We’ve seen the technique of changing the Source already in this Power Query series when we imported from the web. In this example, an Excel Workbook is used as the source, so click Browse to navigate to the new file location, then click OK.ĭepending on the source type, the dialog box will change, but the principles are the same. Thirdly, clicking on the gear icon next to the Source step within the Applied Steps pane will open the source dialog. 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.

Excel 2016 recent files location