Power Pivot and SSRS Reports on SharePoint

RobertCotton

Board Regular
Joined
Nov 1, 2010
Messages
99
Good Morning.

I have been working with Power Pivot for a while now and have become a big proponent. The next step for me is to publish my Power Pivot workbooks to SharePoint so that my "audience" that, in most circumstances, do not have the Power Pivot addin installed can use my reports. Publishing my workbooks to SharePoint seems to be the perfect solution. However, my IT department telling me that the cost of upgrading servers ( both hardware and software) is too prohibitive. They tell me that we would have to move from SQL Small Business to SQL Enterprise and pay individual licensing fees for each user, and on and on and on. I am also tring to get them to install SSRS services so that I can publish SSRS reports to SharePoint and getting much the same story.

While I am not an IT guy, I have done some "due diligence" as far as researching their claims. I have purchased 2 SSRS reporting books that seem to support my position that this is not a big deal.

Does anyone here have any experience with these issues and would you be willing to share those experiences? I have told my boss I can provide him and the rest of the company with all sorts of wonerful new reports using Power Pivot and SSRS only to find hardcore resistance by our IT department in helping me to do so.

Thanks
Robert
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,214,944
Messages
6,122,391
Members
449,080
Latest member
Armadillos

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