3
votes
Accepted
Power Pivot support in SharePoint online
PowerPivot is not available in SharePoint Online. The alternative would be Power BI or using PowerPivot for Excel only. If using PowerPivot for Excel, your users cannot open the Excel directly in SP ...
- 1,321
1
vote
Could not find stored procedure DataRefresh.GetSchedule error when managing SharePoint 2016 PowerPivot data refresh schedules
The [DataRefresh].[GetSchedule] is already removed in SP 2013 as mentioned at the official Microsoft article Changes to PowerPivot Service application database in SharePoint Server 2013
I think you ...
- 45.4k
1
vote
Accepted
PowerPivot Data Refresh Error: Please try again in a little while
SharePoint 2016 web application config file must be updated. The default value is 250MB and the report which scheduled data refresh should not exceed this value.
- 1,737
1
vote
Accepted
PowerPivot Service Application Database is offline
Looks like you used the RAP tool. We had the exact same error reported as critical. Interesting thing is, we are on the standard edition of SharePoint so there is no way to have PowerPivot in that ...
- 56.9k
1
vote
How to use Excel PowerPivot File in SharePoint Online
The reason is that Pivot Tables are still in development. Your test tenant has the option to use Preview Features and therefore allows you to work with Pivot Tables in Excel Online. The official MS ...
- 1,176
Only top scored, non community-wiki answers of a minimum length are eligible