Syncing

Table of Contents

Overview

We currently support the syncing of the following types;

  • Dashboards
  • Reports
  • Tiles
  • Q&A

We do not support syncing of apps, as these do not exist in the Power BI API. You can however sync content from the workspace of the app.

Your content can be kept in a workspace created by any developer, however you must follow the steps under Sharing content with the Power BI Master Account for all content you wish to sync.

Pre-requisites

Power BI Master Account

Content is synced between Enterprise BI Portal and PowerBI.com via a service account called the Power BI Master Account. This account is a standard user account in your Active Directory available via Azure Active Directory that you must create.

You should create this account in your directory and retain the user principal name (account@my.domain.com) and the password for later use. You will need to assign a Power BI Pro licence to this account via the Office 365 Administration Portal.

If you are using App Owns Data embedding, you can reuse the same account.

Azure AD App Registration

To facilitate communication between the Enterprise BI Portal and PowerBI.com with the Power BI Master Account, we will require an Azure App Registration. If you are running the Azure or On-Premises with Azure AD versions of Enterprise BI Portal, this will be in addition to your existing App Registration.

If you are using App Owns Data embedding, you can reuse the same app registration.

Browse to portal.azure.com, then click on ‘Azure Active Directory’ from the menu, followed by ‘App Registrations’ from the Azure AD menu.

step 1

Click on the ‘New application registration’ button.

step 2

Type a name for your application registration.

Select ‘Public client (mobile & desktop)’ from the drop down.

As this is a Native application, you can enter any fictitious URL for the ‘Redirect URI’.

Select the ‘Register’ button to create the App Registration.

step 3

Copy the ‘Application ID’ and ‘Directory ID’ for use in the source system configuration.

Select ‘API Permissions’ from the app registration menu.

step 4

Click the ‘Add a permission’ button from the top of the registered app.

step 5

Select ‘Power BI Service’ from the list of available services.

step 6

Select ‘Delegated Permissions’, permissions will now appear.

Select all permissions as shown in the following two screenshots, then click ‘Add Permissions’

This step requires a Global Administrator account to complete.

step 8 step 9

Click the ‘Grant admin consent for company’ button at the bottom.

This step requires a Global Administrator account to complete.

step 10

Click the ‘Yes’ button to confirm consent.

step 11

Verify you now see the ‘Granted for company’ tick next to each permission.

step 12

Source System Configuration

The last step is to setup the source system from within Enterprise BI Portal, using the information from the above steps.

Browse to the Enterprise BI Portal, and from the top right cog menu, click on ‘Source Systems’.

step 16

Click the ‘New Source’ drop down, then ‘Power BI’.

step 17

Enter the following information as shown in the screenshots below. Once complete, click the ‘Save’ button at the bottom.

Field Description
Name This is a friendly name to identify your source system. If you plan to register multiple Power BI tenancies, you should specify a meaningful name, such as the Azure AD domain that the Power BI tenancy belongs to.
Register assets as this user Because we can’t garuantee that the user who created the asset in PowerBI.com exists in Enterprise BI Portal, we require you to specify an account to appear in the registered by field of the asset.
Tenant ID This should be the tenant ID of the Azure tenancy where the Native App Registration was created earlier.
Azure App Registration Application ID The Application ID of the Native App Registration created earlier.
Power BI Master Account Username (UPN) This is the UPN of the account that you will grant access to content in PowerBI.com
Power BI Master Account Password This is the password of the account that you will grant access to content in PowerBI.com
Import Tiles If you wish to registered individual tiles as assets in the portal, turn this on.
Import Q&A If you wish to registered Q&A as assets in the portal, turn this on.

step 18

step 19

The source system will begin syncing on creation. If you do not see any change, click the ‘Refresh’ button. If the sync does not begin after clicking the refresh button, click the ‘On Demand’ button. Once completed you will see the number of items synced.

step 20

These items will be in the draft area of the BI Portal, you can now begin to publish assets.

Sharing content with the Power BI Master Account

In order for the Power BI Master Account to see your content, you must complete a two step process as shown below.

Add the account as a workspace admin

Browse to the workspace containing your content. Click the ellipse at the top right corner of the page. Click on ‘Edit Workspace’.

master1

Lookup the Power BI Master Account using the ‘Workspace members’ control. Click ‘Add’

master2

Click the drop down for the Power BI Master Account and select ‘Admin’. Click the ‘Save’ button

master3

Share dashboards and reports with the account

Once logged into your desired workspace in PowerBI.com, open up a report or dashboard and select ‘Share’ from the top right hand corner.

25

This will bring up a slide out that will ask you who you wish to grant access to. This is where you enter the user principal name of the master account.

26

You will then receive a notification to confirm that you have successfully shared the dashboard/tile/report with the master account.

27