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

2
votes
1answer
94 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
8 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
1answer
26 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 ...
0
votes
0answers
39 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
27 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
51 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
47 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
9 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
0answers
155 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
288 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 Server ...
0
votes
2answers
65 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
27 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
722 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
78 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
116 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
466 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
944 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
1k 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 ...
0
votes
0answers
39 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
28 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
335 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
146 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
222 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
184 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
268 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
63 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
189 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
37 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
610 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
82 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
93 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
1answer
1k 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
278 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
683 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
208 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
63 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
63 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
986 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 ...
2
votes
1answer
2k 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
333 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
790 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 ...
1
vote
0answers
410 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
46 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
1answer
92 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 ...
2
votes
1answer
2k 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
2answers
150 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
3k 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 ...
1
vote
1answer
475 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
298 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
2k 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 - ...