Here are a few easy steps you can follow to determine exactly what data exists in the model: In Excel, click Power Pivot > Manage to open the Power Pivot window. View the tabs in the Power Pivot window. Each tab contains a table in your model. Columns in each table appear as fields in a PivotTable Field List.

You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can easily manage these connections, including creating, editing, and deleting them.

Excel maintains a list of recently used data sources as a convenience for you to locate and manage them when that’s required. Do one of the following: In Excel Select Data > Recent Sources. In Power Query Editor Select Home > Recent Sources. The Recent Sources dialog appears. Select a data source from the list, and then select Connect.

Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.

Using Microsoft Query, you can connect to external data sources, select data from those external sources, import that data into your worksheet, and refresh the data as needed to keep your worksheet data synchronized with the data in the external sources.

In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share. The tutorials in this series are the following: Import Data …

All of the data that appears in a form, whether this is data that a user can select in a list box, drop-down list box, or combo box, or the data that a user adds to a form, is stored in the form's data sources.

After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data. However, if the source data has been changed substantially—such as having more or fewer columns, consider creating a …

Advice on how to identify, deal with, and resolve errors from externals data sources and Power Query when you refresh data.

You can find cells in a workbook that contain data validation by using the Go To Special dialog box. On the Edit menu, point to Find, and then click Go To. Click Special. Select Data Validation. To find all cells with data validation, select All, and then click OK.