Tag: powerpivot
All the articles with the tag "powerpivot".
-
Windows Already Ships the Decompressor Power Pivot Needs
VertiPaq's xpress8 compression is raw MS-XCA LZ77 behind a two-field wrapper, and Windows has shipped a decoder for it all along. Enough to read the Power Pivot model inside an Excel workbook from a PowerShell script with no dependencies.
-
Parsing Power Pivot Data Models from Excel XLSX Files
Excel workbooks with Power Pivot models contain the same Analysis Services and VertiPaq storage ideas as PBIX files. This article shows how PBIXRay reads them directly from Python.