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

Unable to edit the PowerPivot Gallery windows size in the Oslo style

I have created a new SP13 site using Oslo. PowerPivot Gallery has a very small height parameter which doesn't adjust as items are entered. Research suggest oslo.css may be the culprit but changing ...
0
votes
2answers
22 views

SharePoint 2010 PowerPivot DAX functions

Hi I have a PowerPivot with a calculated column that returns data via the RELATED function. The columns works perfectly except for a handful of rows that return an empty cell. After some ...
0
votes
0answers
32 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
11 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
9 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
25 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
183 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
43 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
35 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
19 views

What is Powerpivot configuration Tool?

I am working on sharepoint 2013 powerpivot. When I ran, "Add-SPSolution –LiteralPath 'C:\Program Files\Microsoft SQL Server\110\Tools\PowerPivotTools\ConfigurationTool\Resources\PowerPivotFarm.wsp'"....
1
vote
0answers
26 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 I ...
0
votes
0answers
20 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
19 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
227 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
146 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
25 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
20 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
42 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
34 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
89 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
21 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 ...
1
vote
1answer
1k 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
35 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
70 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
349 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 ...
2
votes
2answers
53 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
2answers
407 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 ...
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
306 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
101 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
331 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
169 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
835 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
188 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
73 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
405 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
2k 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 ...
5
votes
2answers
3k 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
4k 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
35 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
909 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
306 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
521 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
736 views

PowerPivot We cannot locate a server

I am having the same issue. I tried everything above as well as what was suggested here: http://blog.qumsieh.ca/2013/08/19/ssas-sharepoint-2013-we-cannot-locate-a-server-to-load-the-workbook-data-...
1
vote
1answer
506 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"?
1
vote
0answers
191 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?
3
votes
2answers
3k 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
1k 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: System....