%3CLINGO-SUB%20id%3D%22lingo-sub-571598%22%20slang%3D%22en-US%22%3ESharePoint%20Tidbit%20-%20SPO%20with%20Power%20Pivot%20and%20other%20BI%20stuff%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571598%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Dec%2001%2C%202016%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CDIV%3EHello%20All%2C%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3ERecently%20I%20was%20asked%20the%20question%20%E2%80%9CHow%20do%20you%20use%20Power%20Pivot%20with%20SharePoint%20Online%22%20and%20the%20answer%26nbsp%3Bis%20to%20use%20Excel%202013%20or%20later%2C%20it%20will%20get%20you%20a%20basic%20level%20of%20use%20with%20Power%20Pivot%20and%20SPO%20(E1%20%E2%80%93%20E5%20License)%20as%20suggested%20by%20this%20article%20(See%20all%20Stages%20but%20the%20last%20that%20discusses%20Power%20BI)%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FBI-capabilities-in-Excel-and-Office-365-26c0548e-124c-4fd3-aab3-5f64568cb743%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FBI-capabilities-in-Excel-and-Office-365-26c0548e-124c-4fd3-aab3-5f64568cb743%20%3C%2FA%3E%20.%26nbsp%3B%20You%20will%20need%20to%20install%20the%20add-in%20which%20you%20can%20do%20by%20following%20the%20steps%20in%20this%20article%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FStart-the-Power-Pivot-in-Microsoft-Excel-add-in-a891a66d-36e3-43fc-81e8-fc4798f39ea8%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FStart-the-Power-Pivot-in-Microsoft-Excel-add-in-a891a66d-36e3-43fc-81e8-fc4798f39ea8%20%3C%2FA%3E%20.%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EHere%20are%20two%20articles%20that%20can%20give%20you%20a%20good%20idea%20of%20where%20Power%20Pivot%20started%20and%20where%20it%20is%20going%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsofttrends.com%2F2014%2F02%2F15%2Fpowerview-vs-powerpivot-vs-power-bi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fwww.microsofttrends.com%2F2014%2F02%2F15%2Fpowerview-vs-powerpivot-vs-power-bi%2F%20%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fblogs.office.com%2F2016%2F03%2F14%2Fnew-feature-updates-for-power-pivot-in-excel-2016%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fblogs.office.com%2F2016%2F03%2F14%2Fnew-feature-updates-for-power-pivot-in-excel-2016%2F%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EAnother%20great%20tool%20in%20the%20BI%20stack%20is%20Power%20View%2C%20check%20out%20this%20article%20and%20see%20the%20awesome%20visualizations%20that%20you%20can%20create%20and%20Share%20using%20it%20with%20SPO%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FPower-View-in-Excel-on-Office-365-or-in-SharePoint-Server-99127D68-D7B7-42D0-A4EE-20E2D9897472%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FPower-View-in-Excel-on-Office-365-or-in-SharePoint-Server-99127D68-D7B7-42D0-A4EE-20E2D9897472%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3ENow%20depending%20on%20you%20license%20type%20there%20might%20be%20more%20goodness%20that%20you%20can%20enjoy%2C%20if%20you%20have%20the%20E5%20license%20you%20get%20Power%20BI%20which%20is%20the%20next%20level%20of%20Business%20Intelligence%20tools%20beyond%20Power%20Pivot%20and%20Power%20View%2C%20here%20are%20some%20resources%20to%20help%20you%20learn%20more.%26nbsp%3B%20If%20you%20have%20any%20questions%20please%20let%20me%20know.%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EPower%20BI%20guided%20learning%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fguided-learning%2F%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%26amp%3BfromAR%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fguided-learning%2F%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%26amp%3BfromAR%3D1%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EPower%20BI%20Samples%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fdocumentation%2Fpowerbi-sample-datasets%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fdocumentation%2Fpowerbi-sample-datasets%2F%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EPower%20BI%20Documentation%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fdocumentation%2Fpowerbi-landing-page%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fdocumentation%2Fpowerbi-landing-page%2F%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EPower%20BI%20Blog%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2F%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EPower%20BI%20tutorials%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fuser%2Fmspowerbi%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fwww.youtube.com%2Fuser%2Fmspowerbi%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EInsights%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fsharepoint-online-insights-service-description.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fsharepoint-online-insights-service-description.aspx%20%3C%2FA%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EHave%20fun%20out%20there%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%3EPax%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-571598%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20TECHNET%20on%20Dec%2001%2C%202016%20Hello%20All%2CRecently%20I%20was%20asked%20the%20question%20%E2%80%9CHow%20do%20you%20use%20Power%20Pivot%20with%20SharePoint%20Online%22%20and%20the%20answer%26nbsp%3Bis%20to%20use%20Excel%202013%20or%20later%2C%20it%20will%20get%20you%20a%20basic%20level%20of%20use%20with%20Power%20Pivot%20and%20SPO%20(E1%20%E2%80%93%20E5%20License)%20as%20suggested%20by%20this%20article%20(See%20all%20Stages%20but%20the%20last%20that%20discusses%20Power%20BI)%20https%3A%2F%2Fsupport.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-571598%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EChrisWeaver%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E

First published on TECHNET on Dec 01, 2016

Hello All,

 

 

 

Recently I was asked the question “How do you use Power Pivot with SharePoint Online" and the answer is to use Excel 2013 or later, it will get you a basic level of use with Power Pivot and SPO (E1 – E5 License) as suggested by this article (See all Stages but the last that discusses Power BI) https://support.office.com/en-us/article/BI-capabilities-in-Excel-and-Office-365-26c0548e-124c-4fd3... .  You will need to install the add-in which you can do by following the steps in this article https://support.office.com/en-us/article/Start-the-Power-Pivot-in-Microsoft-Excel-add-in-a891a66d-3... .

 

 

 

 

 

 

Another great tool in the BI stack is Power View, check out this article and see the awesome visualizations that you can create and Share using it with SPO https://support.office.com/en-us/article/Power-View-in-Excel-on-Office-365-or-in-SharePoint-Server-...

 

 

 

Now depending on you license type there might be more goodness that you can enjoy, if you have the E5 license you get Power BI which is the next level of Business Intelligence tools beyond Power Pivot and Power View, here are some resources to help you learn more.  If you have any questions please let me know.

 

 

 

 

 

 

 

 

 

 

 

Have fun out there

 

 

 

Pax