In the Import Data dialog, select an option for how you want the data to be retrieved, and where you want to place the it. Select the database and table or cube that you want to connect to, then click Next.Įnter a name and description for the new connection, and press Finish to save it. In the Data Connection Wizard, enter the Server name, and select a login option. On the Data tab, in the Get External Data group, click From Other Sources, and then click From Analysis Services. In the Navigator pane select the database, then the cube or tables you want to connect.Ĭlick Load to load the selected table, or click Edit to perform additional data filters and transformations before loading it. Note: You have the option of entering a specific database name, and you can add an MDX or DAX query.
