Mobile ApplicationД¬urrently only Power BI offers Q&A. In SharePoint BI, the maximum workbook size is 2GB. (For this reason, make sure to import your data to Power Pivot and not to the worksheet!) That's because within the model it can be compressed and take advantage of the xVelocity engine. Nearly all of the data needs to be in the Power Pivot model because only 10MB is permitted outside of the model. In Power BI, the maximum workbook size currently is 250MB. Enterprise Search is the ability to use Power Query to search for corporate data (or public data) which has been exposed by other users sharing Power Queries, or by the administrator exposing an OData feed. The Search functionality in Power Query is one of my favorite Power BI features, one that has no equivalent in SharePoint BI at this time. Doing a 'Save As' operation creates duplicate copies of the data which isn't an ideal solution. More than a handful of reports gets a bit unwieldy in a single Excel file. I'm sure there's countless technical challenges to make this happen! The person responsible for the data model isn't always the same person creating the reports, so it would be nice to be able to separate them. There's not currently a concept of separating out the data model from the reports, but I sincerely hope that's something the Power BI team can give us. However, in Power BI the data model and the reports (created with Excel pivot tables + charts, or Power View for Excel) everything must be contained within a single xlsx file. This is a great feature because it separates out the data model from the report(s) if desired - hence the term 'workbook as a data source.' This works for Power View for SharePoint, Reporting Services, PerformancePoint, and Excel. In SharePoint, we can upload a Power Pivot model to the Power Pivot Gallery and other reports can connect to it using a URL-based connection string. Workbook as a Data SourceД¬urrently, this is probably the biggest, most important, differences between Power BI and SharePoint BI. In SharePoint BI, the Power Pivot Gallery is a single document library. Although I'd love for this to be a preference whether or not a document library is shown in the Power BI site, I really like this feature because it offers additional flexibility to organize and secure content. Power BI has a very cool feature which displays all document libraries which exist in the Power BI Site.

Power bi edition comparison