Sunday, 12 April 2026 @ 06:31 UTC ~13 12,244 130,110

OLAP PivotTable Extensions

OLAP PivotTable Extensions · GregGalloway.OLAPPivotTableExtensions

An Excel add-in which extends the functionality of PivotTables on Analysis Services cubes, Excel Data Model (Power Pivot), and Power BI

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.

winget install --id GregGalloway.OLAPPivotTableExtensions --exact --source winget

Latest 0.9.7

Release Notes

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/

Installer type: exe

Architecture Scope Download SHA256
x64 — Download 6985E6909D51D38572C8F2D8790907203C732E1D7D632D8BE3CC1828868194E6

Details

Homepage
https://olappivottableextensions.github.io/
License
MS-PL
Publisher
OLAP PivotTable Extensions
Support
https://github.com/OlapPivotTableExtensions/OlapPivotTableExtensions/issues
Copyright
Copyright 2022

Tags

excelpivot-table