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
14 views

Workflow not running when item modified through data refresh

I've created a workflow for a SharePoint 2010 PowerPivot library that runs when an item is changed. The items in the library are changed every day when the data refresh runs. However, the items are ...
1
vote
0answers
45 views

PowerPivot Data Refresh not Working After Adding Pivot Table

I have a spreadsheet with a powerpivot data model in sharepoint 2013 sp1 with sql 2012 sp2 for the power pivot instance. The power pivot data refresh works fine when scheduled, when the spreadsheet ...
1
vote
0answers
16 views

PowerPivot for SharePoint 2013 experience

Does anybody have practical experience with PowerPivot for SharePoint (especially SharePoint 2013) to implement a self-service BI scenario in an on premise environment? Some questions that I’m ...
1
vote
1answer
28 views

What is the optimal approach to disseminate large Powerpivot data model through Sharepoint?

Some background: -I have little understanding of SharePoint as a tool -I work in a large organization that has a collection of sharepoint sites, but where administration of IT resources is highly ...
1
vote
0answers
67 views

Unable to filter Excel web access web part

I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error ...
0
votes
0answers
14 views

Re-Configure PowerPivot 2014 for SharePoint 2013

We've created a new SQL 2014 instance for PowerPivot. I'm trying now to reconfigure the SharePoint part of PowerPivot. I uninstalled the existing PowerPivot I installed it again and started the ...
0
votes
0answers
11 views

Group in the Sharepoint Data Refresh Schedule Notification

I am trying to set up the data refresh schedules for some power pivots I have. There is a field titled "Email Notifications". It currently allows me to create a list of several users however I am ...
0
votes
0answers
55 views

Sharepoint 2013 Document Library Excel oData Data Retrive issue

I am trying to retrieve data from SharePoint Document library to excel using oData Data Feed. My Document library name is "2015" and it have one choice field. I am getting the following error when I ...
0
votes
0answers
30 views

Manage Powerpivot Data Refresh using Powershell

I have looked around quite a bit and haven't found anything on managing the powerpivot data refresh settings / schedule using powershell. Is this even possible? I would like to bulk update some of ...
3
votes
2answers
27 views

Is Claims-based authentication Required for Kerberos and Excel Services?

I'm trying to setup Kerberos for Excel Services + SSAS. SharePoint Web Application pool using Classic Authentication. I was wondering if it's necessary to switch it to claims-based. I've found zero ...
1
vote
0answers
58 views

Combining Similar Lists from Different Sites in One List

is it possible to combine similar lists from different sites in one list so that I can be able to export them as Data Feed and use it in PowerPivot? for example I want to combine Report lists that ...
0
votes
2answers
94 views

Use Powershell to configure PowerPivot Data Refresh Schedules

Is there a way via powershell to check and see which items have a data refresh schedule configured for them? and If they don't proceed to create one? I can't seem to find much on working with ...
0
votes
0answers
32 views

Can we get Excel Pivot chart as an image in SharePoint 2013

I have a workbook which has a pivot chart and we are showing it in Excel services web part. Now my question is: Is it possible to access that chart (as an image) element? I know we can use REST api ...
0
votes
0answers
29 views

Excel refresh and PowerPivot refresh

We're using SharePoint 2013 SP1 and developing dashboards in Excel 2010 with 2012 PowerPivot for Excel. This means that interactive refresh (e.g. refresh on open) is NOT supported according to: ...
0
votes
0answers
129 views

Power Pivot 2013 Using SharePoint 2013 List as Source Data

Background: On a SharePoint 2013 site, there are lists that have the exact same columns but due to their size I had to create a different list for each year. These are essentially my data lists or ...
2
votes
1answer
644 views

External Data Refresh failed - Unable to refresh list data in Excel Web Access WebPart

I have created a PivotChart in Excel workbook that fetches data from a SharePoint list using "OData Data Feed". When refreshing the connection in Excel 2013, the updated data is displayed in ...
0
votes
0answers
18 views

Usage data collection is just working for PowerView reports and not working for PowerPivot reports

I configured the usage and health data collection for PowerPivot service application. Also I checked all these options: PowerPivot Connections PowerPivot Load Data Usage PowerPivot Query Usage ...
0
votes
0answers
73 views

Combined Bar & Line chart in PowerPivot in SharePoint

I have a PowerPivot workbook loaded into a SharePoint 2010 BI Gallery and have a sheet with 4 charts created from the PowerPivot model. The values in the chart are Plan vs Actual numbers and I want ...
1
vote
0answers
108 views

Data Refresh Account - Login Failure: the user has not been granted the requested logon type at this computer

I am trying to configure my Unattended Data Refresh Account and continue to get the following error with the account I am using: The data refresh for 'sqltestrefresh.xlsx' on Report Center - QA ...
1
vote
2answers
47 views

Determine what user is the data refresh account configured by the administrator

Is there a way to get the username that is set as the data refresh account for a power pivot installation? I realize this user is set in the secure store service application but I can't seem to find ...
0
votes
1answer
180 views

Move BI Center (Excel, PerformancePoint, PowerPivot) to other SQL server - SharePoint 2013

What way would be the best to move BI Center to other SQL server in SharePoint 2013? Thanks,
1
vote
0answers
92 views

Data Refresh Error after upgrade PowerPivot from 2008R2 to 2012

after upgrading PowerPivot for SharePoint I cannot refresh the data in all the workbooks. Error appears when opening a workbook in the gallery or in the Scheduled-Data-Refresh. 1. Gallery / ...
0
votes
0answers
21 views

Determine Correct Item URL for Report Library

I am creating a webpart that displays list items from a Report Center that contains both .xlsx files and .rdl files. When I view the .xslx files in the standard SharePoint list webpart it opens them ...
0
votes
1answer
441 views

Error configuring PowerPivot 2012 on SharePoint 2013. New-PowerPivotSystemServiceInstance - The PowerPivot System Service does not exist in the farm

Hi I'm hoping that someone can help me out here. I have a Multi-server dev farm that I am unable to provision PowerPivot correctly. It worked fine on the standalone farm. Any help would be ...
0
votes
1answer
526 views

“We cannot locate a server to load the workbook Data Model.”

I get this error when I open powerpivot documents in sharepoint. "We cannot locate a server to load the workvbook Data Model." after I've looked into the logs I came up with this: Check ...
0
votes
2answers
113 views

PowerPivotConfigTool has stopped working

when I run PowerPivot Configuration tool for the second time(first it ran perfectly), I get this error message while it's in the Examining your system. Please wait... state. Here is what I've got ...
1
vote
0answers
37 views

Is it possible to filter chart without refresh?

I have created a chart in excel using PowerPivot and I am using oData Data Feed to get values from my SharePoint List. I have set auto refresh at every 60 minutes and I have used some filters also. I ...
1
vote
1answer
1k views

Power Pivot and Power View do not work for Excel workbook with external connection

I have SharePoint 2013 with Power Pivot and Power View. It's based on SQL Server 2012. They seem to be configured properly as they work fine with Excel 2010 workbook that contains tabular model that ...
0
votes
0answers
119 views

Can I install PowerPivot SSAS instance on SQL Server not part of the SharePoint farm?

I have an existing on-premise SharePoint 2013 Enterprise edition farm running on SQL Server 2012 SP2 Standard Edition (SQLA). Since SQL Serve is Standard edition I'm not able to leverage all of ...
0
votes
1answer
187 views

Sharepoint: PowerPivot Chart not show + Menu bar not work

Just uploaded a PowerPivot Workbook to a PowerPivot Gallery on Sharepoint 2013 site. I opened it but only the slicers are shown, not the Pivot chart. At the position of the pivot chart, there is ...
0
votes
1answer
814 views

PowerView Configuration: unable to load report designer

I am configuring PowerView for my SharePoint enviornment. I was able to configure everything perfectly in a single server environment, however i am having challages in getting PowerView to work on a ...
4
votes
2answers
2k views

Retrieving list items from multiple sites via OData with Excel

I want to build a report: with Excel 2013 + PowerPivot Add-In using data from SharePoint Online that should work in Excel Services (so I'm not able to use VB, Power Query, etc.) Report should be ...
3
votes
2answers
2k views

We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Interactive report sheets

I use SharePoint 2013 and Power Pivot Services. I create a Excel report with Power Pivot and I fetch data from my Data Warehouse. I upload this Excel file in SharePoint Documents. For update my ...
1
vote
1answer
30 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
582 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
209 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
1answer
266 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
415 views

PowerPivot We cannot locate a server

I am having the same issue. I tried everything above as well as what was suggested here: ...
1
vote
1answer
280 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
739 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
110 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?
2
votes
2answers
2k 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
1answer
887 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
349 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
86 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
83 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
2answers
1k 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 ...
3
votes
2answers
3k 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
493 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 ...
2
votes
1answer
1k 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 ...