Part V: Understanding Power Pivot and Power Query
FIGURE 38.21
The credentials edit screen for your selected data source
Click the Edit button to make changes to the credentials for the data source. The creden-
tials edit screen will differ based on the data source with which you are working, but again,
the input dialog boxes are relatively intuitive and easy to update.
Power Query caches data source settings in a file located on your local PC. Even though you may have deleted a par-
ticular query, the data source setting is retained for possible future use. This can lead to a cluttered list of old and
current data sources. You can clean out old items by selecting the data source in the Data Source Settings dialog box
and clicking the Delete button.
