Introduction to Power BI for Office 365 Admin Center

The Power BI for Office 365 Admin Center allows IT administrators to register on-premises data sources with the portal, enable OData feed for the data sources and select tables/views to be included in the feed, and/or allow Excel workbooks stored in SharePoint Online to be refreshed with data from on-premises data sources. See Supported Data Sources and Data Types for a list of supported data sources.

Scenarios

The two scenarios that the Admin Center supports are:

  • Enable OData Feed: In this scenario, an IT Administrator exposes data from an on-premises data source as an OData feed so that it can be consumed by users such as data stewards and information workers from Power Query for Excel. To expose data from an on-premises data source as an OData feed, the administrator registers the on-premises data source with the Power BI Admin Center, enable OData feed for the data source, select tables/views to be included in the feed, and grant users the access to the feed. Administrators can enable indexing of the data sources so that metadata and data are indexed in the Data Catalog, a component of Self Service Information Management capability of Power BI, so that users will be able search for the feed from Power Query using keywords and consume the feed. Users will also be able connect to the feed by using the feed URL from the Admin Center.
  • Enable Cloud Access: In this scenario, an information worker creates an Excel workbook with a Power Pivot model that uses an on-premises data source of SQL Server or Oracle, tests it, and posts it to the SharePoint Online to share it with others. When the information worker tries to refresh data in the workbook on SharePoint Online, it fails to connect to the on-premises data source. The information worker then contacts an IT Administrator with a link to/copy of the Excel workbook (or) the connection string for the data source. The administrator extracts the connection string from the Excel workbook if needed, uses the connection string to register the on-premises data source with the Admin Center, enable cloud access for the data source, and grant access to appropriate users so that they can refresh the Excel workbook with the latest data from on-premises data sources.

Accessing the Admin Center

After provisioning Power BI for Office 365, you can access the Power BI Admin Center in one of the following ways:

  • Using the Admin Center link under the Admin menu on the Office 365 Admin Center.

Admin Center link under Admin menu

  • Using the Admin Center link under the Tool menu (gear icon) from a Power BI site.

Admin Center menu

 Note    To learn about how to setup Power BI for Office 365, see How to setup Power BI. All global administrators are automatically added to the admin group of Admin Center. Global administrators are allowed to perform operations such as creating a gateway and creating a data source in the Admin Center. You use the role management tab of the Admin Center to add other users to the admin group.

Features of Admin Center

The Admin Center has the following tabs: system health, data sources, gateways, role management, settings, and get started. The following sections describe each tab of the Admin Center.

Power BI Admin Center

System Health Tab

The system health tab allows administrators view the logging information from various operations that administrators perform by using the Power BI Admin Center.

Data sources Tab

After an IT Administrator creates a gateway in the Admin Center, he/she can register on-premises data sources with the Admin Center to support the scenarios described in the Scenarios section. The data sources tab in the Admin Center allows administrators to view all the data sources and their statuses, add a new data source, edit a data source, delete a data source, index a data source, and search for a data source in the list of data sources.

Gateways Tab

The Data Management Gateway is a client agent that is used to connect to a data source in a corporate environment. At least one gateway must be installed in the corporate environment before an IT Administrator can register on-premises data sources with the Admin Center. See Introduction to Data Management Gateway for more details about the gateway.

The gateways tab allows IT Administrators to view all the gateways and their statuses (online, offline, etc…), add a new gateway, edit a gateway, delete a gateway, and search for a gateway in the list of gateways.

Role Management Tab

The role management tab allows an administrator of the Power BI Admin Center to add other users to the admin group. The members of this group are allowed to perform administrative operations such as creating a gateway and creating a data source in the Admin Center. All the global administrators are automatically added to the admin group upon provisioning. This tab also allows an administrator to specify users (data stewards) who can certify queries using Power Query.

Settings Tab

The settings tab allows you to configure general settings and notification settings. The general settings allow you to enable/disable tracking of top users of shared Power queries and windows authentication for OData feed with DirSync. The notification settings include enabling/disabling email notifications when a gateway is expiring/expired and an OData feed indexing operation has failed.

Get Started Tab

The get started tab provides short cuts for steps that a Power BI administrator should perform to expose data from on-premises data sources as OData feeds or to allow Excel workbooks in SharePoint Online to be refreshed with data from on-premises data sources. The tab also provides introductory videos for Power BI administrators.

 Note    The Power BI Admin Center is read-only if the tenant for your organization is in suspended state.

Enable OData Feed Scenario

To expose data from on-premises data sources as an OData feed, you will need to perform the following steps:

  1. To register on-premises data sources with the Power BI Admin Center, you first need to download, install, and configure a Data Management Gateway on an on-premises computer and then register the gateway with the Admin Center. See Install, Configure, and Register Data Management Gateway for details.
  2. In the Power BI Admin Center, register the on-premises data source with the Power BI Admin Center, enable OData feed for the data source, select tables and views to be included in the OData feed, and grant users the access to the feed. See Create a Data Source and Enable OData Feed in the Power BI Admin Center for details.

Enable Cloud Access Scenario

To enable cloud access for an on-premises data source, you will need to perform the following steps:

  1. To register on-premises data sources with the Power BI Admin Center, you first need to download, install, and configure a Data Management Gateway on an on-premises computer and then register the gateway with the Admin Center. See Install, Configure, and Register Data Management Gateway for details.
  2. In the Power BI Admin Center, register the on-premises data source with the Power BI Admin Center, enable cloud access for the data source, and grant users the access to the data source. See Enable and Secure Cloud Access for an On-Premises Data Source using the Power BI Admin Center for details.

See Also

 
 
Applies to:
Power BI for Office 365