With the Power BI sites application, you can transform your SharePoint Online site into a more robust, dynamic location to share and find Excel reports, 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. Add the Power BI sites app to your Power BI site.
Power BI site for Office 365 site with downloaded sample
View a report on the Power BI site
You can view reports 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 report to a Power BI site.
Tip Don’t have a Power BI site? You may need to add the Power BI sites app to your Power BI for Office 365 site.
- In the Power BI site, choose the report you want to view in the browser.
You may see an “Editing Restriction” message that the Data Model in the report is optimized for Web viewing. This means the report is larger than 10 MB. You can still view and interact with it in the browser, but you can only edit it in Excel.
Tip When the report opens, it has no menus, such as File and Edit Report. To see the menus, choose View full-size report in the lower-left corner.
You see the same reports in your standard SharePoint Documents library and in the Power BI site – the Power BI site is just another, richer view of those reports. If you delete a report from the Power BI site, you’re deleting it from the SharePoint Documents library, too.
The Power BI site currently only shows Excel reports 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.
More in this article
View Power View sheets in HTML5
When you view an Excel report with Power View sheets in the browser, you have the option to view those Power View sheets in HTML5 instead of in Silverlight.
- Open an Excel report from the Power BI site or the standard SharePoint Documents and navigate to a Power View sheet in the report.
- Choose the HTML5 Version icon in the lower-right corner.
- To go back to the Silverlight version, choose Take me back.
More about the HTML5 version of Power View.
Make a report a favorite on your My Power BI site
You can make reports your favorites. All of your favorite reports appear together on the favorite reports page of your My Power BI site.
- On a Power BI site, choose the ellipsis (…) next to a report > Favorite.
From the ellipsis (…), choose Favorite.
More about favorites on your My Power BI site.
Feature a report on a Power BI site
You can feature a report so it appears at the top of a Power BI site. Everyone who visits the site sees the featured reports. You can feature up to three reports. If you add a fourth report, the report that was featured first falls off the list.
- On a Power BI site, choose the ellipsis (…) next to a report > 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.
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 report to a Power BI for Office 365 site
Enable web viewing for a report in Power BI for Office 365 sites
View your My Power BI site
Reduce the size of an Excel report on a Power BI for Office 365 site
Troubleshoot Power BI sites
Power BI forums