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.

learn more… | top users | synonyms

0
votes
0answers
5 views

PowerPivot Gallery in Application using Forms Based Authentication

I have modified an existing web application to use forms based authentication. The problem is that now the gallery snapshot fails after the scheduled refresh. Is there any workaround for this. Even if ...
1
vote
1answer
16 views

How does licencing for Sharepoint (BI tools) on O365 work?

I'm looking at http://www.microsoft.com/en-us/powerBI/pricing/buy-bi.aspx The PowerBI addon licence grants me the following extra features: BI Sites Scheduled Data Refresh Data Stewardship ...
0
votes
0answers
21 views

PowerPivot for Sharepoint 2013 - Cannot generate thumbnail error

I'm trying to get the thumbnail to appear in the PowerPivot Gallery. However I'm getting the error message "An error occurred while capturing snapshots for this document". I've tried disabling ...
0
votes
1answer
21 views

PowerPivot for SharePoint 2013 - GallerySnapshot.exe 0KB

For some reason, the GallerySnapshot.exe located in the 15 hive of SharePoint 2013 was modified and became 0 KB. Where can I get this file? Can someone provide this file? Thanks!
0
votes
0answers
15 views

Powerpivot Configuration Fails when Creating PowerPivot Service Application

I am trying to configure powerpivot for sharepoint 2010 using the configuration tool. I can seem to get all the pieces working other than creating the service application. Here is the output from ...
0
votes
1answer
20 views

Get-SPExcelServiceApplication Cmdlet not recognized during Powerpivot configuration

I am trying to run the sharepoint powerpivot configuration tool however I am getting a message saying: The term 'Get-SPExcelServiceApplication' is not recognized as the name of a cmdlet, function, ...
0
votes
0answers
23 views

PowerPivot We cannot locate a server

I am having the same issue. I tried everything above as well as what was suggested here: ...
0
votes
0answers
12 views

Pivot Table Operation Failed business intelligence Sharepoint 2013

If i try to interact with Power Pivot in the Sharepoint Site It shows me error Pivot Table Operation Failed. I tried with gogle and search a lot of samples but nothing works.
1
vote
1answer
33 views

Restrict permissions for PowerPivot

Is it possible to configure the permissions for a Power Pivot library such that users can reference the Power Pivots as a data source for Excel or Power View, but not "download a copy"?
0
votes
0answers
16 views

Uninstall/reinstall PowerPivot

I am thinking I need to unintall/reinstall PowerPivot on my SP 2013 (single-server) farm, due to the fact that I mistakenly installed it when I had the wrong version of Analysis Services installed on ...
0
votes
0answers
99 views

PowerPivot Management Dashboard: Workbooks do not update in Excel Services

[Running SP 2013 Enterprise SP1 w/ SQL Server 2012 SP1] I having a couple problems with the PowerPivot Management Dashboard. (Well, maybe more than a couple but I am focusing on these right now.) If ...
1
vote
0answers
26 views

How can I remove Excel menu in web apps in Share Point 2013?

I use SharePoint 2013 and I use Power Pivot Service. When I open an Excel Report, I see this report : How can I remove Excel menu(File/Open In Excel / Data/...) from this report?
0
votes
0answers
22 views

Removing PowerPivot for SharePoint fails

I am setting up SP 2013 Enterprise on Server 2012. There were some problems with using PowerPivot so I decided to remove it using the PowerPivot Configuration Tool. (I installed it with the same.) ...
1
vote
0answers
277 views

An error occurred while loading the model for the item or data source 'EntityDataSource'

I use SQL Server 2012 SP1 U8 and SharePoint 2013. I configure Excel Service and Performance Point Service and PowerPivot Service. I create an Excel File`that fetch data from Data Warehouse in ...
0
votes
0answers
62 views

SP 2010 PowerPivot Data Refresh Problem : Access is Denied!

I've a PowerPivot workbook which has an embedded data connection - (Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI) to a SQL server DB and simply pulls a table ...
0
votes
1answer
82 views

PowerPivot Manage Data Refresh Error

I am getting an error message when i click on Manage Data Refresh for PowerPivot workbook. ERROR An unexpected error has occurred. Here is ULS Log. EXCEPTION: ...
0
votes
1answer
26 views

How can I install `SQL Server PowerPivot For Sharepoint` for `Sharepoint 2013`?

I have Share Point 2013 and SQL Servere 2012 SP1 in my serever. I want install SQL Server PowerPivot For Sharepoint. I run SetUp of SQL Server 2012 SP1 and in Setup Role I Select SQL Server ...
1
vote
1answer
34 views

How to enable Power View in SharePoint 2013?

I use SharePoint 2013 and Performance Point Service for create Business Intelligence report. But I need more functionality in report generation. I found that Power View in this scenario can help me. ...
0
votes
1answer
33 views

PowerPivot Data Refresh

We have a user who had configured powerpivot data refresh jobs with his account. So, when he changed his password, his domain user account is getting blocked because of many wrong log-in try. Can I ...
0
votes
1answer
182 views

Gallery View of a PowerPivot Gallery not working

I am using SharePoint Server 2013. I have a Power Pivot Gallery with several Power Pivot Excel files and Power View files. Besides All Documents view, the Power Pivot Gallery has several beautiful ...
1
vote
1answer
495 views

MidTier process account should have 'Full Read' permission on all associated SPWebApplications

I'm getting a Health Rule throwing the error in the title. Full details on this: MidTier process account should have 'Full Read' permission on all associated SPWebApplications It also gives a ...
0
votes
1answer
93 views

Feature '1a33a234-b4a4-4fc6-96c2-8bdb56388bd5' Pivot?

Feature '1a33a234-b4a4-4fc6-96c2-8bdb56388bd5' for list template '10002' is not installed in this farm. The operation could not be completed. I'm trying to figure out why I'm receiving this ...
1
vote
1answer
189 views

Thumbnails/snapshots don't show in PowerPivot Gallery when the document refreshes on open

I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the ...
0
votes
0answers
167 views

Problem connecting Sharepoint 2010 to SSAS through a RSDS

As the title says, I'm trying to create a Report Data Source on Sharepoint 2010 where I have an SQL2012 instance with the PowerPivot, SSRS and the sharepoint add-in configured. I choose "Microsoft ...
2
votes
1answer
38 views

Can people play with fields using PowerPivot?

I began on a BI job a few months ago and one of my first tasks is to replace our current way to access the SSAS cubes. It is a custom web application based on OWC (which is now deprecated) and it's ...
0
votes
0answers
125 views

Error when dragging measures to power-view report

I'm trying to connect to a AnalysisServices instance, version 11.0.3373.0 on SQL Server 2012 SP1 CU5. In SharePoint, I click on create powerview report from the datasource. I can explore the cube ...
0
votes
1answer
46 views

Can I limit what a user can see in a PowerPivot table/chart (e.g. slicer shows their department[s] only) using their AD credentials?

I want to produce a number of PowerPoint tables and charts and make them available to my entire management team but limit it so that the Department slicer only shows the department(s) that they ...
0
votes
0answers
51 views

Creating a Data source to a XLSX

I am reading this tutorial http://technet.microsoft.com/en-us/library/hh759324.aspx I download the xlsx workbooks and the images as instructed. my installation is working perfectly and I can create ...
0
votes
0answers
14 views

SharePoint List and Map

How can I create a display of a list of assets, and a powerpivot map, with selection either in the map or on the list narrowing down what is displayed, on a site? I've got a list of assets I would ...
2
votes
1answer
794 views

Cannot create a PowerPivot data connection (PerformancePoint Services in SharePoint Server 2013)

I can create data sources that connect to SQL Analysis Servier 2012 instances, but not to the PowerPivot instance. I followed the instructions here: ...
0
votes
1answer
76 views

Power BI for “Corporate” BI?

Managing SharePoint on-premises is tedious and problematic, and I can't wait to completely abandon on-prem and move to SharePoint Online. But basic Power Pivot support isn't even close as a ...
3
votes
0answers
1k views

We cannot locate a server to load the workbook data model

This is the error that appears when I try to refresh data. I have been struggling with this issue for a few weeks. Researching in internet but with no luck. My sharepoint site is 2013 and SQL Server ...
0
votes
1answer
285 views

SharePoint 2013 Manage Reporting Services Application crashing

I had integrated reporting services working nicely, then I changed something and when I go into Manage Reporting Services Application -> System Settings this happens: Sorry, something went wrong The ...
0
votes
1answer
145 views

Export Data Feed for Forms Library (Infopath) for Reporting

I need to create reports based on the Infopaths submitted in the forms library. This library will act as data source for my reports (reports like how many forms are submitted / some pie charts etc.) ...
0
votes
1answer
865 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
231 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
149 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 ...
1
vote
0answers
115 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
402 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 ...
1
vote
0answers
27 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
75 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
174 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
370 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
2k 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
330 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
1answer
102 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
43 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
3answers
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
466 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
1k 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 ...