OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on all types Analysis Services cubes. It supports Analysis Services Tabular, Analysis Services Multidimensional, Azure Analysis Services, and Power BI (both Analyze in Excel and the XMLA endpoint). The Excel API has certain PivotTable functionality which is not exposed in the UI. OLAP PivotTable Extensions provides an interface for some of this functionality. It also adds some new features like searching cubes, configuring default settings, and filtering to a list in your clipboard. The add-in can be launched from the menu option in the right-click menu for PivotTables.
What's new in 0.9.7
This release contains support for Excel 2013 and Excel 2016 and Excel in Office 365 (Microsoft 365). The installer supports both 32-bit and 64-bit Excel. To run OLAP PivotTable Extensions in Excel 2007 or Excel 2010, use Release 0.8.4. Release 0.8.4 is not supported to be run side-by-side with newer releases. New Features - Upgraded to latest ADOMD.NET driver and forced TLS1.2 which fixed support for: - Azure Analysis Services - Power BI Analyze in Excel - Power BI XMLA endpoints Bug Fixes - Fixed Problem Getting Power BI access Token - Fixed Can't Filter List with Power BI Connection again - Fixed Error message: App property was not recognized This release requires the .NET Framework 4.5.2 and will install it if it is not installed already. Just download and run the EXE. There is no need to uninstall the previous release. If you have problems getting the add-in to work, see the Troubleshooting Installation wiki page. OLAP PivotTable Extensions documentation is at https://olappivottableextensions.github.io/
OLAP PivotTable Extensions is ms-pl software from OLAP PivotTable Extensions. Check the publisher's license terms for pricing and usage rights.
What is the latest version of OLAP PivotTable Extensions?
The latest version is 0.9.7, released on Sep 14, 2022.
Is it safe to download OLAP PivotTable Extensions?
The download button links to the official installer published on github.com, the same file Windows Package Manager installs. You can verify the downloaded file by comparing its SHA-256 checksum with 6985e6909d51d38572c8f2d8790907203c732e1d7d632d8be3cc1828868194e6.
Which Windows versions does OLAP PivotTable Extensions support?
OLAP PivotTable Extensions runs on Windows and is available for 64-bit (x64) systems.
How do I install OLAP PivotTable Extensions silently?
Run the offline installer with "OLAP.PivotTable.Extensions.Setup.v0.9.7.exe" /S /V/quiet /V/norestart, or install it with Windows Package Manager: winget install --id=GregGalloway.OLAPPivotTableExtensions -e --silent.
How do I uninstall OLAP PivotTable Extensions?
Open Settings › Apps › Installed apps, find OLAP PivotTable Extensions and select Uninstall. From the command line, run winget uninstall --id=GregGalloway.OLAPPivotTableExtensions -e.
Alternatives to OLAP PivotTable Extensions
Other System Utilities programs for Windows from different developers.
Chocolatey is The Package Manager for Windows. It was designed to be a decentralized framework for quickly installing applications and tools that you need. It is built on the NuGet infrastructure and
