With the Power BI sites application, you can transform your SharePoint Online site into a more robust, dynamic location to share and find Excel workbooks, with a visual, interactive view tailored to BI. Power BI sites also provide easy access to other BI features available in Power BI for Office 365.
The Power BI sites app is available when you register for Power BI for Office 365. You can apply it to a new or an existing site in SharePoint Online Enterprise.
You can see the same workbooks in your standard SharePoint Documents library and in the Power BI site – the Power BI site is just another, richer view of those workbooks. If you delete a workbook from the Power BI site, you’re deleting it from the SharePoint Documents library, too.
The Power BI site currently only shows Excel workbooks stored on the site. If you have other files on the site, you can see them in the SharePoint Documents library, but not in the Power BI site view.
Register for Power BI for Office 365.
In this article
View a large workbook on the Power BI site
You can view workbooks up to 250 MB in a browser on Office 365, if you save and enable them on the Power BI site.
- If you haven’t done so already, save the workbook to a Power BI site.
- In the Power BI site, click the workbook you want to view in the browser.
You may see an “Editing Restriction” message that the Data Model in the workbook is optimized for Web viewing. This means the workbook is larger than 10 MB. You can still view and interact with it in the browser, but you can only edit it in Excel.
Reduce the size of an Excel workbook on a Power BI site.
View Power View sheets in HTML5
When you view an Excel workbook with Power View sheets in the browser, you have the option to view those Power View sheets in HTML5 instead of in Silverlight.
- Open a workbook from the Power BI site or the standard SharePoint Documents and navigate to a Power View sheet in the workbook.
- Click the HTML5 Version icon in the lower-right corner.
- To go back to the Silverlight version, click Take me back.
Read more about HTML5 version of Power View.
View your My Power BI site
Your My Power BI site houses your favorite reports and data about your reports and queries.
- On a Power BI site, click My Power BI. in the upper-right corner next to your name.
Make a workbook a favorite on your My Power BI site
You can make workbooks your favorites. All of your favorite workbooks appear together on the favorite reports page of your My Power BI site.
- On a Power BI site, click the ellipsis (…) next to a workbook > Favorite.
When you make a workbook a favorite, you aren’t making a copy of the workbook or moving it from its location. You’re just creating a view that brings together pointers to your favorite workbooks.
Only you can see your My Power BI site, but other people can see the workbooks on the sites where they’re stored. You can add workbooks to your My Power BI site from different sites, as long as the sites are on the same SharePoint Online tenant.
Remove a workbook from your favorites (“unfavorite”)
- On your My Power BI site, click the ellipsis (…) next to a workbook > Unfavorite.
Removing a workbook from your favorites doesn’t delete it. It’s still on the site where it’s stored.
View query use and data sources on your My Power BI site
The data page on the My Power BI site shows information about:
- Queries you created with Power Query.
- Data sources you can use in Power Query.
Feature a workbook on a Power BI site
You can feature a workbook so it appears at the top of a Power BI site. Everyone who visits the site sees the featured workbooks. You can feature up to three workbooks. If you add a fourth workbook, the workbook that was featured first falls off the list.
- On a Power BI site, click the ellipsis (…) next to a workbook > Feature.
View query usage analytics and manage data sources
The Power BI site also provides access to the Manage Data portal. From the portal, you can:
• View usage analytics for queries shared within your enterprise using Power Query.
• View and manage data sources in Power BI.
Read more about the Data Management Experience in Power BI for Office 365.
The Power BI for Office 365 Admin Center
IT Administrators use the Power BI for Office 365 Admin Center to set up infrastructure in the cloud and on-premises so that they can expose data from on-premises data sources as OData feeds that can be consumed from Power Query for Excel. IT Administrators can also monitor the overall system health in the cloud and on-premises by using the Admin Center.
Read more about the Power BI Admin Center.
More about Power BI sites and Power BI for Office 365
Register for Power BI for Office 365
Add the Power BI sites app to your Power BI site
Save a workbook to a Power BI site
Enable web viewing for a workbook in Power BI for Office 365 sites
Reduce the size of an Excel workbook on a Power BI site
Troubleshoot Power BI sites
Business intelligence capabilities in Excel and SharePoint Online
TechNet Article: Business intelligence capabilities in Excel 2013 and SharePoint Online
Power BI forums