Overview: Exporting Data to Excel (MDS Add-in for Excel)

Applies to: SQL Server - Windows only Azure SQL Managed Instance

In the Master Data Services Add-in for Excel, you must export data from the MDS repository into an active Excel worksheet before you can work with it. When you are done working with the data, import it to the MDS repository so other users can share it.

The data you can export is limited to the data you have permission to access. Permission to access data is set in the Master Data Manager web application or set programmatically.

When you export 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.

Warning

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).

Filtering Data

You can filter data before exporting 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 Exporting (MDS Add-in for Excel).

Connect Automatically and Load Frequently-Used Data

If you want to always connect to the same server and export 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).

Refreshing Data

Data in the MDS repository may be updated by other users after you export 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).

Task Description Topic
Filter MDS data before you load it into Excel. Filter Data before Exporting (MDS Add-in for Excel)
Load MDS data into Excel. Export Data to Excel from Master Data Services
Change the order of columns before you download data. Reorder Columns (MDS Add-in for Excel)