We have SharePoint 2010 environment and we are using Power Pivot service for reporting and data source as SharePoint list.
Since now we are migrating to SharePoint online (Office365), So Could anyone suggest me What is best to use Power Pivot with SharePoint Online.
- Is SharePoint Online supports Power Pivot?
- Compatibility and support of Power Pivot with SharePoint Online?
- Is it best way use Power Pivot on SharePoint Online also? or is there any better solutions present with SharePoint Online like PowerBI?
- If PowerBI, then how we will gonna move my existing Power Pivot report to PowerBI?
Any information will be useful, so please comment your thoughts.