Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
18 views

PowerPivot - On demand data refresh

I have schedule data refresh and least you can do is 1 data refresh per day. Is there a on demand data refresh option. I click on Data > Refresh selected connection from the web view of the xlsx but ...
2
votes
2answers
67 views

PerformancePoint vs PowerPivot > Which one

I have not worked with either one. So before I get deep into either one I want to make sure I am picking the right engine for business intelligence. There are needs for reports, pie charts or ...
2
votes
2answers
30 views

Crunching numbers according to user-defined formulas: best approach?

I have been trying different solutions to this problem, including a completely custom data processing module; now I feel like I've run out of options and was wondering what people thought was the best ...
1
vote
1answer
37 views

Scheduled copy of Excel spreadsheet

Background We have a requirement to provide our client updated metrics data on a weekly basis. We wanted to deliver som wow so I built out a prototype in Excel using PowerPivot. All is well and good. ...
1
vote
1answer
39 views

Error with credentials installing SQL 2008 R2 PowerPivot on SharePoint 2010 Front End

Scenario: We have a server farm that consists of (2) back-end servers, (2) web front-ends that are accessed via the internal network, and (2) web front-ends that are accessed from outside the network ...
5
votes
3answers
69 views

Graphics in/with SharePoint 2010

I'd like to know if it's possible to Is it possible to generate graphics in/with SharePoint 2010 as Excel used to generate graphics and curve based on datas. I have heard about PowerPivot but don't ...
1
vote
1answer
55 views

PowerPivot MultiRefresh Per day

Is there any way to configure the schedule refresh of the PowerPivot file to refresh the file many times per day. even with writing custom code. Thanks in advance for you support
0
votes
0answers
164 views

PowerPivot Data Refresh Exception

I am trying to resolve the following Error in my ULS logs. I have a ticket open with Microsoft and even they cannot get it resolved yet so I thought I would post it here. These errors come in pairs ...