Chapter 38: Introducing Power Query
38
For instance, let’s say you connected to a SQL Server database, entered all of your creden-
tials, and imported the data you needed. At the moment of successful connection, Power
Query caches information about that connection in a file located on your local PC. This
includes connection string, username, password, privacy settings, and so on.
The purpose of all this caching is so that you don’t have to re-enter credentials each time
you need to refresh your queries. That’s nifty, but what happens when your credentials are
changed? Well, the short answer is those queries will fail until the data source settings are
updated.
Editing data source settings
You can edit data source settings by activating the Data Source Settings dialog box. To do
so, click Data ➪ Get Data ➪ Data Source Settings.
The Data Source Settings dialog box, shown in Figure 38.20, contains a list of all creden-
tials-based data sources previously used in queries. Select the data source you need to
change and then click the Edit Permissions button.
FIGURE 38.20
Edit a data source by selecting it and clicking the Edit button.
Another dialog box will pop up, this one specific to the data source you selected (see
Figure 38.21). This dialog box enables you to edit credentials as well as other data privacy
settings.