How to import data into Excel from SSAS Tabular model as Table?

Viewed 1915

I'm trying to import data from SSAS Tabular Model into Excel worksheet. Steps sequence:

  1. On the Data tab -> From Other Sources -> From Analysis Services
  2. Select Database and Model
  3. Save Data Connection -> Finish

And then appeared the popup window (see below) where I can choose how I want to view this data and there Table option is inactive (see below).

Maybe someone know why it's inactive and how I can get my data imported as a simple table?

enter image description here

And yes... I personally NEVER saw this Table option as active.

1 Answers
Related