--- title: "Sync Analyze Dashboards and Dataset to Customer PowerBI" slug: "sync-analyze-dashboards-and-dataset-to-customer-powerbi" tags: ["PowerBI"] updated: 2026-10-21T17:10:51Z published: 2026-10-21T17:10:51Z canonical: "docs.eshare.com/sync-analyze-dashboards-and-dataset-to-customer-powerbi" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.eshare.com/llms.txt > Use this file to discover all available pages before exploring further. # Sync Analyze Dashboards and Dataset to Customer PowerBI This document describes the necessary steps to synchronize the eSHARE Analytics Dashboard and the underlying Power BI dataset from eSHARE infrastructure to a dedicated Power BI Workspace created in the Customer’s Azure tenant. The following steps will be reviewed: - [Why Should We Do This?](/collaborate/docs/sync-analyze-dashboards-and-dataset-to-customer-powerbi#why-should-we-do-this) - [Authorize the eShare PowerBI Automation Service Principal (Consent URL)](/collaborate/docs/sync-analyze-dashboards-and-dataset-to-customer-powerbi#authorize-the-eshare-powerbi-automation-service-principal-consent-url) - [Authorize the eShare PowerBI Automation Service Principal (PowerShell)](/collaborate/docs/sync-analyze-dashboards-and-dataset-to-customer-powerbi#authorize-the-eshare-powerbi-automation-service-principal-powershell) - [Allow Service Principal to Access the PowerBI REST API](/collaborate/docs/sync-analyze-dashboards-and-dataset-to-customer-powerbi#allow-service-principal-to-access-the-powerbi-rest-api) - [Provide Service Principal Access to the Workspace](/collaborate/docs/sync-analyze-dashboards-and-dataset-to-customer-powerbi#provide-service-principal-access-to-the-workspace) > **REQUIREMENT:** > > The Person performing these steps must have an administrator role assignment of **Application Administrator**, **Cloud Application Administrator**, **Fabric Administrator**, or **Global Administrator** in the destination M365 tenant. ### **Why Should We Do This?** - Having the eSHARE dataset synced to your PowerBI allows BI developers to enhance it with additional data sources and create custom reports. - It facilitates sharing reports with custom filters with other internal users. - Synchronization is one-way so there is no impact to the original dataset and visualizations provided by eSHARE. - Ability to integrate the dataset with other automation triggers and workflows (*ex. Power Automate*) - Allows your users to subscribe to reports. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/eshare---replicating-pbx-in-customer-tenant---commercial-image-lxurvwwj.jpg?sv=2026-02-06&spr=https&st=2026-11-18T20%3A16%3A59Z&se=2026-11-18T21%3A16%3A59Z&sr=b&sp=r&sig=mLk9hxR9JLHYZQAkU37emiSrrNhU3m2EFaSyxs4c9l0%3D) ### **Authorize the eShare PowerBI Automation Service Principal (Consent URL)** The '**eShare PowerBI Automation**' application is owned by eSHARE, published and verified by Microsoft Partner Network. 1. Login to the Entra Identity Portal as an Administrative user (*For Commercial Customers:* [*https://entra.microsoft.com*](https://entra.microsoft.com) *| For Government Customers:* [*https://entra.microsoft.us*](https://entra.microsoft.us)). 2. In the left navigation pane, select '**Entra ID**' > '**Overview**', then find and copy the **Tenant ID**. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 23.35.36@2x(1).png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A16%3A59Z&se=2026-11-18T21%3A16%3A59Z&sr=b&sp=r&sig=vi0vpUaxROpng3ZvXHoIbAOIB5k1JGs7eodDSkK%2BoCw%3D) 1. Open a new browser Tab/Window in the same session and enter the following URL, replacing the '***{tenant_id}***' section with your Organization’s Tenant ID. **Azure Commercial Customer URL** ```plaintext https://login.microsoftonline.com/{tenant_id}/adminconsent?client_id= 3d81e65d-fc33-4a36-94a4-b690d4c3dc03 ``` **Azure Government Customer URL** ```plaintext https://login.microsoftonline.us/{tenant_id}/adminconsent?client_id=4ff15db4-4168-4d1d-9e92-f7434abb96ec ``` 1. When prompted, sign in to the M365 admin account, an App called '**eShare PowerBI Automation**'. 2. Review the requested permissions and select '**Accept**' to add the application. > [!WARNING] > Note: > > The '**PowerBI Automation**' application does not require any MS GRAPH permissions, only the service principal entity needs to be created which will then be given access through PowerBI RBAC. The delegated MS GRAPH permission of '**user.read**' is only requested due to a minimum requirement of having 1 permission for consent. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-16 at 22.41.21@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A16%3A59Z&se=2026-11-18T21%3A16%3A59Z&sr=b&sp=r&sig=M1BofBzN3xTVOKV7F4oPf%2BstWOGF4OKx2aaXqbLf5ik%3D) 1. After the app has been approved, the page will be redirected to [eshare.com](https://www.eshare.com), which indicates the application has been successfully Installed. 2. Navigate back to the '**Enterprise Applications**' section in Entra ID. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-16 at 23.41.17@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A16%3A59Z&se=2026-11-18T21%3A16%3A59Z&sr=b&sp=r&sig=9FgW5pDkmOaB4m5Ak1Xul9fbck0%2F6s3yyUT2UdcfaNE%3D) ### **Authorize the eShare PowerBI Automation Service Principal (PowerShell)** An alternative means to consenting for the '**eShare PowerBI Automation**' Service Principal is utilizing PowerShell. Running the below commands will create the Service Principal in your tenant without having to consent for MS GRAPH permissions. > [!WARNING] > Note: > > The '**Application.ReadWrite.All**' permission is a delegated permission needed for the M365 administrator to run the PowerShell Command. Running this command does not consent this permission for the Service Principal. The '**New-MgServicePrincipal**' command creates the application in your Azure Tenant ([Official Microsoft Documentation](https://learn.microsoft.com/en-us/entra/identity/enterprise-apps/create-service-principal-cross-tenant?pivots=msgraph-powershell#create-an-enterprise-application)). **Commercial Cloud PowerShell Commands (https://graph.microsoft.com)** ```powershell connect-MgGraph -Scopes "Application.ReadWrite.All" ``` ```powershell New-MgServicePrincipal -AppId 3d81e65d-fc33-4a36-94a4-b690d4c3dc03 ``` **Government PowerShell Commands (https://graph.microsoft.us)** ```powershell connect-MgGraph -Environment USGov -Scopes "Application.ReadWrite.All" ``` ```powershell New-MgServicePrincipal -AppId 4ff15db4-4168-4d1d-9e92-f7434abb96ec ``` ### **Allow Service Principal to Access the PowerBI REST API** 1. Go to the '**PowerBI Admin Portal**' (*For Commercial Customers:* [*https://app.powerbi.com/admin-portal*](https://app.powerbi.com/admin-portal/) *| For Government Customers:* [*https://app.high.powerbigov.us/admin-portal*](https://app.high.powerbigov.us/admin-portal)). 2. In the left navigation bar, select the '**Tenant Settings**' tab (should be default landing page). 3. Navigate down the page and locate the '**Developer settings**' section. 4. Enable the '**Allow service principals to use PowerBI APIs**' toggle. 5. Select an option under '**Apply to**' and then '**Apply**' the changes. > [!WARNING] > Note: > > It is recommended to add the '**eShare PowerBI Automation**' Service Principal to a M365 Security group, then add this group to the PowerBI APIs allow list. Avoid opening the PowerBI APIs to the entire organization. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-17 at 08.34.21@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A16%3A59Z&se=2026-11-18T21%3A16%3A59Z&sr=b&sp=r&sig=h6ZJWpBzkwuZA8%2Ba8VXXM9nCKv%2FJGWDPA3DBKKAkEUQ%3D) ### **Provide Service Principal Access to the Workspace** 1. Create or identify a Workspace where the Dataset and Dashboards should be synced to. 2. Within the Workspace select '**Manage access**' in the top right corner of the page. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-17 at 08.41.34@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A16%3A59Z&se=2026-11-18T21%3A16%3A59Z&sr=b&sp=r&sig=%2FGaNiL34y9xy8h%2BNrw4bk33%2Bu4q%2BnJvDmrEcSb11MU4%3D) 1. On the '**Manage access**' pop out window, select the '**+ Add people or groups**' button. 2. Search for the Service Principal '**eShare PowerBI Automation**' and add it as a member of the workspace. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-17 at 08.38.43@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A16%3A59Z&se=2026-11-18T21%3A16%3A59Z&sr=b&sp=r&sig=u4Ym8%2F3BvQ1PIxfdVr0JbUtIkw5%2FeQuwpN88Dorh9%2Fw%3D) 1. Lastly, gather the following information and provide it to your eSHARE Customer Success Manager so they can complete the connection: 1. M365 Tenant ID 2. Name of the PowerBI Workspace 3. Desired name of the Dashboard