Connect PowerPivot (2010) to another PowerPivot (2010)

[BobbyBull2009]

Hi,

I have an Access database where I upload data from several sources. I then use this file to create a PowerPivot database in Excel, to which I add several calculating columns, relationships and hiding some column lists from the "client tools".

Once I have done this, the PowerPivot is ready to be used. The intension is that it would be used by several people with me being the "administrator". That said, I would make changes both to the Access database and to the PowerPivot database (making adjustments where necessary).

Question: How can I use this PowerPivot database as the central database to which everyone can connect their own analysis file? I read something about using SharePoint, but I am not familiar with the concept.

Any advice?

Thank you in advance.

 

[Matt Allington]

SharePoint is a good option, but you need SharePoint Enterprise. Read my blog post here Using SharePoint Enterprise with Power Pivot -

Power BI is the hot new thing. You can now publish Excel Workbooks online

 

[Matt Allington]

Pin Excel to Power BI Dashboard is Disappointing -. Link to how to do it in Excel