MDS entities can be created with data from the Excel Add-in. In this example, we will load data from a database table into an Excel sheet and then create an MDS entity using the structure and data taken from the Excel sheet.
Open an empty workbook in Excel and go to the Data tab.
Click on the From Other Sources option (in the Get External Data section) and select From SQL Server.
Enter
localhostas the SQL server name, then select AdventureWorksDW2012 as database, and select DimProductCategory. Click on Continue to finish. You will see the product categories listed in the Excel sheet.Go to the Master Data tab. Connect to the MDS connection that you created in first example of this chapter.
Select the cells of the Excel sheet that contain the data of the product category. Then click on the Create Entity icon in the Master Data tab under the Build Entity section.
Choose PacktPub_BI_Model as model, leave the version as is, and...