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

Enable Hyperlinks from Sharepoint in Excel

I have exported a SharePoint list to Excel using OData Feed connection, then uploaded the sheet to a SharePoint PowerPivot gallery. The SharePoint list have hyperlink fields, I want to enable them ...
0
votes
0answers
9 views

PowerPivot Performance Dashboard - How do I customize it?

I am a farm administrator and the performance dashboard that I see for all the PowerPivots hosted is good but I need to customize it a bit. My question is, when I try to connect to the SSAS cube which ...
0
votes
0answers
8 views

One SQL PowerPivot instance for SharePoint for two separate SharePoint Farms?

Can I use one SQL PowerPivot instance for SharePoint for two separate SharePoint Farms? I use SharePoint 2013 SP1 and SQL 2012.
0
votes
0answers
11 views

powerpivot data refresh works in all document except for .xlsm

I recently upgraded SharePoint 2010 to Sp2013. After the upgrade i created a secured stored services to do the scheduled data refresh on excel sheet with external data connections. All of the excel ...
0
votes
0answers
70 views

Cannot Create the service instance because the parent Service does not exist. “Powerpivot Fail”

You cannot vote on your own post 0 I have been trying to install powerpivot for SharePoint Feature in our SharePoint 2013 Enterprise Farm. I installed SQl for powerpivot instance called "POWERPIVOT" ...
1
vote
1answer
28 views

What are the reporting services in SharePoint 2013? What is difference between PerformancePoint, PowerPivot & Powerview reporting services?

Since first time got an opportunity to work on reporting services and new to it. Want to know that what are the reporting services. What is the difference between them. What is the actual use of it. ...
0
votes
0answers
22 views

Powerpivot Configuration rules missing after recent update

I have SharePoint 2013 Server License with 5 server in my tier. 2 WFE and 3 App Server. One of the App server is hosting Powerpivot with SQL analysis services instance. I recently ran Powerpivot ...
0
votes
0answers
13 views

What is Powerpivot configuration Tool?

I am working on sharepoint 2013 powerpivot. When I ran, "Add-SPSolution –LiteralPath 'C:\Program Files\Microsoft SQL ...
1
vote
0answers
21 views

How can I have end-users visualizing different dimensions from the same Powerpivot on same excel file?

I need help to understand if it is possible to have end-users visualizing different dimensions from the same excel file published in Sharepoint 2013. I have a data warehouse in SQL Server 2012 and ...
0
votes
0answers
15 views

Post upgrade issues with PowerPivot

I'm testing the in-place upgrade process to get from SSRS and PowerPivot 2008 R2 to 2014. I've started by upgrading the POWERPIVOT instance on the first of my 4 SharePoint farm servers and everything ...
0
votes
0answers
14 views

SharePoint With PowerPivot Filters Missing

I upgraded existing Excel2010 spread sheet to excel2013 as part of SharePoint upgrade from sp2010 to sp2013. Everthing works fine but i dont see any filters being populated on sharepoint excel ...
0
votes
0answers
152 views

The user name or password is incorrect-Log on failed. The remote server returned an error: (500) Internal Server Error

Situation: 1. Windows 2008 R2 Data Center Edition > Data Base Server – Microsoft SQL 2008 R2 RTM > Data Base 2. Windows 2008 R2 Enterprise > WFE – SharePoint 2010 Enterprise – PowerPivot ...
0
votes
0answers
73 views

PowerPivot Management Dashboard Processing Timer Job Fails

Been having an issue with our PowerPivot config that has plagued us. MS Support even has yet to resolve. So with much trial and error, we did successfully configure SSAS in SP mode, the service app ...
0
votes
0answers
23 views

Error when trying to create SQL Server PowerPivot Service Application

We recently migrated our 2010 environment to 2013. Everything is working except for Power Pivot. We're attempting to create a SQL Server PowerPivot Service Application and we're getting the ...
0
votes
0answers
19 views

Retrieve PowerPivot sheets and thumbnails using SharePoint Client API

Using the SharePoint C# client API I am able to retrieve the names of files in a SharePoint PowerPivot Gallery, however, some PowerPivot files include multiple sheets, and SharePoint stores thumbnail ...
0
votes
0answers
34 views

Is it possible to hide open in excel icon for the PowerPivot Gallery

Sharepoint 2013 on Prem. Does anyone know about a way hide/disable open in excel icon in the PowerPivot gallery (silverlight app)? So OWA is the only way to open PowerPivot/view spreadsheet? ...
0
votes
1answer
21 views

PowerPivot database not deleted from tabular database

I am testing SharePoint 2013 / SQL Server 2014 combination. I upload a PowerPivot Excel to PowerPivot gallery and do some testing. I notice that when I delete the PowerPivot from the PowerPivot ...
0
votes
0answers
55 views

Export list to excel issues with data type number

so I have a two lists that are connected using lookup, when i export the list to excel the number column (its a lookup column) shows as 10.000000 instead of just 10.. I have tried formatting the cells ...
0
votes
0answers
16 views

Refresh data in online PowerPivot Excel sheet?

I have a Excel sheet that loads the data from a SharePoint list. If I do the following I get below error: Make a pivot table to display data. Save and upload the sheet. Now to Refresh the data to ...
0
votes
0answers
88 views

PowerView Export to PowerPoint Functionality in Office 365

I am looking to be able to export a PowerView document to PowerPoint but cannot seem to find that functionality in the latest release. I am using Excel 2013, latest updates, and a SharePoint Online ...
0
votes
0answers
31 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
1answer
773 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
28 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
61 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
278 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
28 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
22 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
178 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
125 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 ...
2
votes
2answers
42 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 ...
0
votes
0answers
60 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
293 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
50 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
60 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: ...
2
votes
1answer
1k 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 ...
1
vote
0answers
242 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
83 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
283 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
140 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
1answer
1k 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
725 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
157 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
62 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
2k 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
1answer
340 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
1k 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 challenges in getting PowerView to work on ...
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
3k 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
34 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
815 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 ...