PowerPivot is a powerful data mashup and data exploration tool based on xVelocity in-memory technologies providing analytical performance to process billions of rows at high speed.
0
votes
1answer
13 views
Excel services and PowerPivot error: “Unable to refresh data for a data connection in the Workbook. ”
My environment is a 3-tier SharePoint 2010 Architecture: Running on SQL Server 2012 Enterprise Edition
WF1
WF2
Both Web Fronts are NLB, and we have they following Application Servers
APP1 - ...
0
votes
0answers
57 views
ListData.svc gives a 500 error when querying some lists
I'm trying to use ListData.svc to retrieve details from a SharePoint list, but I get the following error:
============================
Error Message:
Cannot connect to the specified feed. Verify ...
0
votes
1answer
39 views
Implementation of power view in sp 2013 - Pain Points and Ideas
Can anybody please give me some painpoints of using PowerView in sharepoint 2013.
Recently in our project we are planning to upgrade our site from SP2010 to 2013. In SP2010 site we have lots of ...
0
votes
0answers
173 views
SharePoint 2010 PowerPivot Excel Web Access dynamic refresh
We have SQL Server 2008 R2 (x64) with MSOffice 2010 (x64) and PowerPivot x64.
We created a custom list "InformationList". We then used the "Export as Data Feed" option to generate a .atomsvc file ...
1
vote
0answers
66 views
Use an Access Web Database as a data source for Excel?
I have an Access 2010 Web Database published to SharePoint as described here:
http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx
If my Access ...
1
vote
1answer
80 views
Powerpivot data refresh over kerberos delegation
I have a SQL 2008 R2 OLAP Cube and an Excel file that uses powerpivot and embedded datasource to the Cube.
I want to upload the Excel file in SharePoint and allow users who are authenticated to the ...
0
votes
0answers
70 views
How can I schedule recurring email in sharepoint 2013
I have set of Power View reports and Excel reports on Sharepoint 2013. Is it possible to schedule email to send snapshot of Power View and Excel reports daily to a set of users?
1
vote
0answers
22 views
Auto Generated Folders inside Layout and other folders after installing PowerPivot for SharePoint 2010
We have installed PowerPivot for SharePoint in our Windows Server 2008 R2 and Configured its all services and everything works fine. But suddenly i found that there are many auto generated folders by ...
0
votes
1answer
48 views
How to refer to a local file for a PowerPivot datasource?
We have users trying to use Performance Point and need to point to a local PowerPivot file as a data source. The instructions state:
Type the connection string to the PowerPivot data source by ...
1
vote
0answers
102 views
PowerPivot workbook as PerformancePoint data connection
I have uploaded a PowerPivot workbook to the PowerPivot Gallery and am now attempting to use it as a data source for PerformancePoint, but I keep received the following error when making the ...
0
votes
1answer
213 views
Cannot install SQL Server (2012) PowerPivot for SharePoint, always fails Sharepoint Version check
Trying to install a fresh install of Sharepoint 2010 (w/ SP1) Enterprise Evaluation and SQL Server 2012 PowerPivot for Sharepoint.
The prerequisites clearly show that Sharepoint 2010 SP1 is needed, ...
2
votes
1answer
626 views
Why is my PowerPivot gallery not showing snapshots?
after creating a PowerPivot document, my PowerPivot Gallery is looking like the image below.
The red cross message is "An error ocurred while capturing snapshots for this document".
How can I solve ...
2
votes
0answers
184 views
offline and online (SP 2010) version of Excel with slicer
An user uploaded Excel with Pivot that has slicer to sharepoint document library. The data for this excel coming from SQL backend.
The browser gives following error.
"The workbook cannot be opened ...
0
votes
0answers
81 views
Unable to refresh a workbook in a Pivot Gallery
I have a workbook in a Pivot Gallery, and when I try to refresh all the data connections I get the following error:
Unable to refresh data for a data connection in the workbook. Try
again or ...
0
votes
0answers
122 views
PowerPivot with MySQL connector
I have a powerpivot document using a MySQL connector and when added to SharePoint it doesn't seem to think it has a dataconnection.
Is there anyway to get this type of powerpivot document to work ...
0
votes
0answers
115 views
“An error has occured” while opening PowerPivot workbook on Sharepoint
I've created powerPivot workbook and uploaded on Sharepoint PowerPivot Gallery. I also created data refreshing schedule. But when I try to open uploaded workbook I get an error:
An error has ...
0
votes
0answers
55 views
Is it possible to sort by month name in PowerView?
Is it and if how possible to sort by month name without having to add a number in front in Powerview? I would like to change these month id's to month literals so 1 > JAN:
Screenshot 1
0
votes
1answer
74 views
Power Pivot files loading
I have a sharepoint dev installed on my local win7 box (sql server 2012 is also local and everything is running under my AD account, whihc is an admin account)
I manage to install a PowerPivot ...
-1
votes
1answer
40 views
powerpivot configration
i installed sql server 2008 and SharePoint 2010 and finished the installation of the pivot but when i clicked start - 1 all programs -sql server 2008 - configuration tools -
(but the only thing exist ...
1
vote
2answers
2k views
Unable to Refresh the Excel Connection in Excel Webaccess Webpart
I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection.
It throws an error.The scree shot is attached.
I have ...
0
votes
0answers
303 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 ...
3
votes
3answers
844 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
96 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 ...
2
votes
1answer
104 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
366 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 ...
6
votes
2answers
173 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 ...
2
votes
2answers
279 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
1answer
589 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 ...
