Wednesday, July 25, 2012 5:35 PM
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.
Thursday, July 26, 2012 12:04 AMYes - it's possible. You can connect to SSAS tabular similar to how you connect SSAS OLAP via excel.
Thursday, July 26, 2012 10:51 AM
... 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?
Friday, July 27, 2012 9:12 AMModerator
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
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Saturday, August 04, 2012 7:21 AM