Any API(Java or others) to connect and read PowerPivot data..

sourav.majumder

New Member
Joined
Sep 5, 2012
Messages
5


Below are the questions I have - 1. Is there any java API to connect and read the PowerPivot excel 2010 data? 2. Is there any web service available to connect and read the PowrPivot data? 3. Any .Net API to do the same? 4. Once imported how and in what structure PowerPivot stores the data with the excel? How to understand the relationship and read the data?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Hello

PowerPivot has no API. On the other hand, if interested in the Tabular engine, you *can* code one through .Net interfaces.

However, most of the time what you want is to extract data our of the engine. If this is the case, once you publish to a PowerPivot Gallery in SharePoint, you can query the PowerPivot model through DAX or MDX, and as so consume its data in .Net or a tool that understands OLAP/MDX (even non-Microsoft ones).

An example of this approach is posted here: PowerPivot and Beyond: Expanding your analytical repertoire « Javier Guillén



Javier Guillen
 
Upvote 0
Thanks for the information.
Once the PowerPivot excel is published in SharePoint, is there any web service available to interact with the data? What about PowerPivot web service?
Can we publish PowerPivot excel as a service in SharePoint so that a wsdl will be published in sharepoint and Using my client application we can call those?
 
Upvote 0
There is no wsdl interface. The interface to query data can be done through the SQL Server Analysis Services provider. If you are using .net, you can use the ADOMD.Net API to query data or metadata for the published PowerPivot model (in SharePoint). This interface uses XMLA when communicating with the server model, though you will be issuing an MDX statement.

Here is an example using a multidimensional SSAS cube:

Retrieving Data Using the CellSet

As PowerPivot (when published to SharePoint) is hosted as a model that has multidimensional interfaces, you can use the same method to programmatically retrieve data.
 
Last edited:
Upvote 0
from the powerpivot window directly, no. If I understand your questions correctly, you seem to be interested in consuming PowerPivot as a service. Is this right? When using PowerPivot in SharePoint, it *is* in fact hosted in a service (the SSAS dedicated service), and you can then query the model hosted on this service to retrieve data and save it in other formats (you can query it from Excel or other tools that understand MDX or DAX)
 
Upvote 0
1. I want to read PowerPivot data that appears in tabular format in Excel with PowerPivot plugin.
2. I tried with Apache POI, it can't do this. Any other Java API or any other languages can fulfill req as mentioned in 1.
3. Next thought of any service format it can be exposed in Sharepoint so that I can write a Java client to read the data?

4. Per your reply is it possible to call the SSAS service and fire query from any Java client?
 
Upvote 0
in that case, yes you do need SharePoint so you can then query the SSAS service which hosts the PowerPivot data.

Another option is moving the PowerPivot model to a full blown SSAS BISM Tabular environment, in which you won't need SharePoint (or Excel) anymore.

As long as you can use the SSAS provider you can query the PowerPivot hosted model or SSAS Tabular environment from code. The link I gave above details how to access a multidimensional SSAS environment from .Net code; I am not familiar with a Java implementation.
 
Upvote 0
I am trying to find out how to create a SSAS service endpoint / Webservice endpoint in SharePoint which hosts and can interact with PowerPivot embedded data.

Can u please provide some guidance.

Thanks for providing me the most accurate answers, I do appreciate your help.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top