Loading Data (MDS Add-in for Excel)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
In the Master Data Services Add-in for Excel, you must load data from the MDS repository into an active Excel worksheet before you can work with it. When you are done working with the data, publish it to the MDS repository so other users can share it.
The data you can load is limited to the data you have permission to access. Permission to access data is set in the Master Data Services web application or set programmatically.
When you load large amounts of data, you can set warnings that are displayed when the data that might take a long time to load. To do this, in the Options group, click Settings. On the Data tab, select the Display filter warning for large data sets.
An MDS-enabled workbook must be opened and updated only in Excel with the MDS Add-in for Excel. Opening an MDS-enabled workbook in Excel on a computer in which the MDS Excel Add-in is not installed is not supported, and could cause corruption of the workbook file. If you want to share data with someone else, email a shortcut query file to them, rather than saving the worksheet and emailing it. For more information on the query, see Email a Shortcut Query File (MDS Add-in for Excel).
You can filter data before loading to limit the amount of data that you’re going to download. This includes choosing which attributes (columns) you want to load, the order you want to display the attributes, and the members (rows of data) you want to work with. For more info see Filter Data before Loading (MDS Add-in for Excel).
If you want to always connect to the same server and load the same set of data, you can create shortcut query files, which contain connection and filter information. For more information about query files, see Shortcut Query Files (MDS Add-in for Excel).
Data in the MDS repository may be updated by other users after you load it. You can retrieve this data without losing changes you’ve made to non-MDS data. For more information, see Refreshing Data (MDS Add-in for Excel).