Connecting to Analysis Services through Excel


Just a quick one with some pretty pictures..

Step 1: Select a nice blank cell in Excel (B4 for instance)


Step 2: From the Data tab on the ribbon, select From Other Sources > From Analysis Services


Step 3: Enter the name of the server you want to connect to


Step 4: Click Next and then select the name of the Cube to which you want to connect from the dropdown


Step 5: Select the location of your new pivot table


Step 6: click OK and Robert’s your Mother’s brother.


One thought on “Connecting to Analysis Services through Excel

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s