Exploring data source settings
Once you have the connections to the data, it is possible to edit the credentials for each connection you have used, not just for the active connection, but for all the connections that you have made. This means that if your data source is located in a folder called sales
, but now you want the connection to be in a subfolder of sales
, you need to be able to change the source settings so that Power Bi/Power Query knows where to look. We will learn how to do this in Excel next.
From Excel
There are different ways in which you can get to the same destination. I have added three here:
- If you are in Excel and you have loaded the query into a table, then you can click anywhere in the table and select Edit from the Query ribbon. This will open Power Query Editor:
- Alternatively, you can right-click the query in the Queries & Connections window and select Edit, which will...