Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
1answer
27 views

Could not find stored procedure DataRefresh.GetSchedule error when managing SharePoint 2016 PowerPivot data refresh schedules

Upgrading from SharePoint 2013 to 2016 and ReportingServices/PowerPivot (SharePoint integration), when users attempt to modify an existing PowerPivot schedule, Reviewing the SharePoint logs, there ...
0
votes
1answer
14 views

PowerPivot Schedule Refresh - A schedule cannot be enabled for a workbook with no external data sources

First of all, here is a bit about my SharePoint installation SpWeb = SharePoint front end SpApp = SharePoint application server SpDB = SharePoint Database OOS = Office online server Analysis ...
3
votes
0answers
19 views

ADO.NET Data Services for SharePoint 2016?

As I was asking in a related question, I'm trying to figure out how to get a PowerView report going that is using a SharePoint list as its data source. In researching how that can be done, I found ...
2
votes
2answers
240 views

Power Pivot support in SharePoint online

We have SharePoint 2010 environment and we are using Power Pivot service for reporting and data source as SharePoint list. Since now we are migrating to SharePoint online (Office365), So Could anyone ...
1
vote
1answer
33 views

powerpivot excel sheets in Sharepoint online?

We have finally decided to move SharePoint On prem to SharePoint Online. In our on prem site we have BI site where we house 15-20 excel sheets which utlize powerpivot within them which gets refreshed ...
2
votes
1answer
81 views

PowerPivot Managment dashboard 2016 not extracting Usage.Requests during Usage data Collection

After upgrading to SharePoint 2016 we noticed that the Usage.Requests table in the PowerPivot Service Application database is not being populated. all the other tables are storing information, but ...
1
vote
1answer
43 views

Problem when I try to do a data refresh

I'm having trouble with data PowerPivot data refresh... I have made 2 workbooks: 1 - Put some random data, to use this workbook as a data source. I put it on SharePoint server PowerPivot gallery... ...
1
vote
0answers
14 views

Cannot select the sandbox cube from a PowerPivot workbook as a data source for PerformancePoint

I have a bi site in SharePoint that has a PowerPivot workbook with a data model. I have obtained the connection string and trying to add a data source but after I enter the connection string the ...
0
votes
0answers
243 views

PowerPivot Datarefresh Error: Call to Excel Services returned an error

I'm getting this error when I tried to schedule a datarefresh at a PowerPivot report. Some datarefresh scheduled jobs are working fine but at one report schedule is not working properly. I found ...
0
votes
0answers
40 views

PowerPivot Data Refresh Error - Class Not Registered

I've a powerpivot report and some excel files are using this powerpivot data as source. Nowadays all clients are getting this "class not registered" error when they try to change filters on excel ...
1
vote
0answers
50 views

Unable to import SharePoint list in Excel when using Forms authentication

I have a SharePoint team site published on the internet with forms authentication enabled. I can access it on browser using http://myteamsite:1080 and then it displays a form where I enter my user/...
1
vote
1answer
114 views

PowerPivot Data Refresh Error: Please try again in a little while

I scheduled data refresh on a power pivot but I'm getting this error. Here is ULS logs. How can I solve this issue? Any suggestion? What does "Please try again in a little while" means? :/ ...
0
votes
1answer
162 views

PowerPivot Data Refresh Schedule Timeout Error

I am getting timeout error when I schedule data refresh, but I can refresh data manually. Data refresh unattended account has enough permissions for database server and tables. Is there any idea why I ...
1
vote
0answers
19 views

why is PowerPivot Health Statistics Collector Timer Job trying to get data from an older powerpivot instance?

We are relocating one SSAS PowerPivot service instance from the local server to a remote one, but the timer job is still trying to connect to the service instance and we are getting empty values. we ...
1
vote
0answers
20 views

Excel Services PowerPivot - Item Level Permission

I have implemented PowerPivot Chart, PowerView and uploaded the same to PowerPivot gallery on BI Site. Excel Services is configured with "Unattended Service Account" to retrive data from Data Source. ...
1
vote
0answers
22 views

SharePoint 2013 Power pivot in excel no found

I have a Sharepoint2013 (Enterprice) with excel services installed and power pivot with SQL SERVER 2012 R2 (Enterprice). In another physical server i have a SQL Server 2008 (Enterprice) and i have 14 ...
0
votes
1answer
219 views

Scheduled Managed Data Refresh does not work

I have a situation where Manage PowerPivot Data Refresh feature has suddenly stopped on Site collection. I can see the Data Refresh History which shows all the previous daily automatic data refresh ...
1
vote
1answer
49 views

PowerPivot Service Application Database is offline

I recently used an assessment tool which gave me the error in the title. Description: PowerPivot Service Application database is offline eventhough the PowerPivot Service Application & proxy ...
1
vote
2answers
331 views

Power View reports no longer open in SharePoint - “Server cannot be found”

I have SharePoint 2013 + SQL Server 2012 SSAS Tabular Mode + SSRS running in SharePoint integrated mode for business intelligence reports. This is in 2 environments, QA and PROD, which are identical ...
3
votes
1answer
2k views

How to use Excel PowerPivot File in SharePoint Online

I have a very basic Excel PowerPivot data model that I moved to SharePoint online. The file that I'm testing with is a basic Excel file, that contains no external data connections, and the pivot ...
4
votes
0answers
29 views

PowerPivot library - Gallery view is tooooo big

Is there way to create a new view where PowerPivot gallery view is 4 icons across. The current view is large icons in one row and If i have 50 documents then it's hard to find. Please suggest.
1
vote
1answer
79 views

Connect Excel PowerPivot to SSAS using HTTP access

Need to connect PowerPivot to SSAS using HTPP access. The Table Import Wizard gives the error below when Importing data to PowerPivot (just from the client machine, its works just fine for me!). An ...
2
votes
0answers
53 views

Why does the Manage PowerPivot Data Refresh page show a data source that is not in the workbook being configured?

I have several Excel workbooks hosted on an on-premises SharePoint installation that are refreshed each day. Each workbook accesses one of our Analysis Services cubes via Excel Services. When I went ...
1
vote
0answers
58 views

Powerpivot refresh Error

The data refresh is working fine in my test environment ,But in production it is a new server and i had created a tabular model and roles and deployed to same share point ,When i try to refresh within ...
1
vote
2answers
321 views

Slicers not showing up in PowerPivot Gallery

I uploaded a workbook with pivot charts and slicers to a PowerPivot gallery, the chart shows, but the slicers do not; unless I select "Edit in Browser" for the workbook. What would cause the ...
3
votes
1answer
366 views

Confused about Excel Services vs PowerPivot

I've been setting up a kind of a BI solution in SharePoint with very limited SP experience, and even though it now kind of works, I'm rather confused about how it actually works. Let me elaborate on ...
0
votes
2answers
39 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
95 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 ...
1
vote
1answer
82 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. ...
1
vote
0answers
41 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
1answer
66 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 ...
1
vote
1answer
3k 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
48 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
111 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
676 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
116 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
1k 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
2k 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
415 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
167 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
448 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
227 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 / ...
1
vote
1answer
2k 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 ...
4
votes
1answer
2k 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
284 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
121 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
3k 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
597 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 ...
1
vote
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 ...
6
votes
3answers
5k 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 ...