Power BI for Office 365 - Service Description

Note   This article applies to the previous Power BI experience (commonly called Power BI for Office 365), and not to the new Power BI experience. Try the new Power BI. Read more about migrating from Power BI for Office 365 to the new Power BI.

Power BI for Office 365 provides powerful new ways to work with data in Excel and Office 365. The Power BI for Office 365 service includes the following capabilities:

  • Create collaborative Power BI sites to share interactive reports and custom datasets.

  • Use the Data Management Gateway to manage and refresh data connections.

  • Curate corporate data, and share and annotate data queries.

  • Consume Excel workbooks that include Power Pivot models and Power View visualizations; render workbooks up to 250MB in Excel Online.

  • Consume Excel workbooks using mobile applications.

For more information on all features, see Power BI for Office 365 – Content and Learning.

In Excel, you use the built-in capabilities of Power Pivot and Power View to model and visualize data, get even more powerful results by using Power Query to import, merge and shape data; and use Power Map to produce 3D visualizations of geospatial data. To take advantage of Power BI capabilities in Excel, you need Office 365 ProPlus, which is not included in the license for the Power BI for Office 365 service.

Software requirements

For information about the operating systems, web browsers, and applications that are supported by Office 365, see the following resource:

Power BI boundaries and limits

There are some limitations to SharePoint Online, such as site collection quotas, file upload limits, and storage limits. Power BI for Office 365 extends certain limitations, such as extending the maximum workbook size to 250MB for rendering in Excel Online, rather than the SharePoint Online maximum of 10MB for Excel Online rendering. There may be specific limits to Power BI for Office 365, the details of which will be available in the future.

For details, see SharePoint Online software boundaries and limits. In addition, there are certain types of files that you cannot upload or download in a SharePoint list or library; see blocked file types for details.

Applies To: Excel 2013, Power BI

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language