Latest Power Pivot Version

%3CLINGO-SUB%20id%3D%22lingo-sub-1670941%22%20slang%3D%22en-US%22%3ELatest%20Power%20Pivot%20Version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1670941%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Office%20365%20Excel%20with%20Power%20Pivot.%20My%20question%20is%20can%20I%20download%20a%20latest%20version%20of%20Power%20Pivot%20and%20get%20it%20into%20my%20Excel%20as%20Add-In%3F%26nbsp%3B%20The%20problem%20I'm%20having%20is%20my%20version%20of%20Power%20Pivot%20does%20not%20have%20the%20rather%20new%20function%20CONVERT()%3B%20Power%20Bi%20on%20my%20computer%20does%20have%20it.%26nbsp%3B%20I%20need%20it%20in%20Power%20Pivot.%26nbsp%3B%20CONVERT()%20was%20released%20about%20sept%202019%20and%20my%20Excel%20version%201910%20is%20dated%20Oct%202019%20so%20it%20should%20have%20but%20does%20not%20have%20this%20function.%26nbsp%3B%20Thanks%20for%20any%20insight%20and%20response.%26nbsp%3B%20Jeff_Logan077%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1670941%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1671113%22%20slang%3D%22en-US%22%3ERe%3A%20Latest%20Power%20Pivot%20Version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1671113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F794887%22%20target%3D%22_blank%22%3E%40Jeff_Logan007%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Pivot%20is%20built%20in%20Excel%20staring%20from%20Excel%202016%2C%20it's%20not%20any%20more%20downloadable%20and%20separately%20installed%20add-in.%20Thus%20it%20is%20updated%20together%20with%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFunctionality%20of%20Power%20Pivot%20is%20relatively%20far%20behind%20compare%20to%20Power%20BI%20Desktop%20and%20Analysis%20Server.%20Some%20DAX%20functionality%20could%20be%20implemented%20with%20big%20delay%2C%20some%20perhaps%20will%20never%20be%20implemented%20(as%20bi-directional%20relationships).%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAt%20the%20same%20time%20for%20some%20DAX%20functions%20which%20actually%20exists%2C%20Power%20Pivot%20editor%20shows%20as%20not%20recognized%20(as%20TREATAS()%20).%20You%20won't%20know%20till%20press%20Enter%20(or%20you%20already%20knew).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have Office 365 Excel with Power Pivot. My question is can I download a latest version of Power Pivot and get it into my Excel as Add-In?  The problem I'm having is my version of Power Pivot does not have the rather new function CONVERT(); Power Bi on my computer does have it.  I need it in Power Pivot.  CONVERT() was released about sept 2019 and my Excel version 1910 is dated Oct 2019 so it should have but does not have this function.  Thanks for any insight and response.  Jeff_Logan077

1 Reply

@Jeff_Logan007 

Power Pivot is built in Excel staring from Excel 2016, it's not any more downloadable and separately installed add-in. Thus it is updated together with Excel.

 

Functionality of Power Pivot is relatively far behind compare to Power BI Desktop and Analysis Server. Some DAX functionality could be implemented with big delay, some perhaps will never be implemented (as bi-directional relationships). 

 

At the same time for some DAX functions which actually exists, Power Pivot editor shows as not recognized (as TREATAS() ). You won't know till press Enter (or you already knew).