I have Done a Pivot-table with External Data Connection as Analysis Serivce CUBE and Published in Sharepoint Document Library.
Iam able to browse the Excel sheet but geting a error saying : " External Data Ranges(also called Query tables) the following feature is not supported)
How to resolve this?
Is this Unsupported Feature in Excel Services.
If you want to work with table data based on an external data connection in Excel Services, you can't use an external data range (also called a query table). You must create
a PivotTable report that flattens multidimensional, hierarchical data into a table, or two dimensions. Here is an official article about use a
PivotTable report to make external table data available in Excel Services:
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?