Excel 2010 to read a SSAS tabular data structure

Question

Hi,

I need to know if it is possible to publish to SharePoint Server 2010 and use an Excel 2010 workbook (not PowerPivot workbook) that queries a SSAS tabular data structure.

Thanks

Answer 1

Yes - it's possible. You can connect to SSAS tabular similar to how you connect SSAS OLAP via excel.

---

Karthik

Answer 2

... and then I can publish my Excel workbook, without using PowerPivot, on SharePoint Server 2010 with Excel Services, isn't it?

Can I use Excel 2007 to connect to a SSAS tabular?

Thanks

Answer 3

Hi pscorca,

We can connect to tabular model databases from Excel2010, the Excel 2007 doesnot suppprt connect to tabular model databases. Here are some articles for your reference, please see:
Use a BI Semantic Model Connection in Excel or Reporting Services: http://technet.microsoft.com/en-us/library/hh230901.aspx
Tabular Model Data Access: http://technet.microsoft.com/en-us/library/hh230973.aspx
Connect to a Tabular Model Database (SSAS): http://technet.microsoft.com/en-us/library/gg492136.aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support