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
1answer
34 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
131 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 ...
3
votes
2answers
297 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
588 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
25 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
24 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
96 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
79 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
91 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
64 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
109 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
27 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
88 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
26 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
362 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
44 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
44 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
617 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
136 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
271 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
78 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
52 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
49 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
459 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
1k 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
186 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
416 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
245 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
44 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
173 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
62 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
59 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
1k 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
95 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
2k 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
349 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
193 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
1k 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 - ...
1
vote
0answers
254 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
164 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
150 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
503 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
84 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
202 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
481 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
407 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
108 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 ...