Each of the Data View Toolset web parts uses data-sources to connect to query and retrieve data. The available data-sources are:
SharePoint site url
Site where the list/library that you wish to display is located.
Select the list/library that you want to display.
Select the view that you want to display.
Max number of items
This property allows you to limit the number of items returned from the data source.
Select if you wish to limit the aggregation to a specific content type.
Add search scope
Click the button to add a new search scope. Each search scope is limited to a site collection and provides additional filtering properties, identical to the ones described for the "List Aggregator" data source in previous section.
The Excel file datasource enables you to connect to a MS Excel file located in a SharePoint library, by using Excel Services. It includes the following properties:
Type the cell range that define the data you wish to display
IMPORTANT: Connecting to an Excel file is done by using the built-in Excel services. If Excel services are not available or return no results (may happen with large files), the MS Graph API is used instead. In that case the "site assets" library is not supported by Microsoft Graph, so make sure to store your excel file in another library.
So for example, you can get your recent files from OneDrive, display your Outlook meetings and tasks, or display organization hierarchy based on Azure AD.
When you edit the Graph API datasource you'll see 2 settings pages:
SharePoint User Profiles service allows you to load user profile information from SharePoint. This data source provides data that is specifically designed to work with Org Chart controls. It includes the following properties:
Start account login
Choose a user account to start the search from. If left empty - current user's login will be used as the search starting point.
Number of levels to load
Limit the number of hierarchy levels to load.
The External Data feature (part of KWizCom modern apps) enables creating external data sources, which connect to web services. An external data source encapsulates the data about the connected web service, including the retrieved data columns. Click here to learn more about the External Data feature.