Skip to main content

Power BI Premium Endpoint

Note: Released in Jet Analytics Data Integration 6024.1.

This article describes how to deploy and execute the Deliver instance to the Power BI Premium XMLA Read/Write Endpoint.

Configure Power BI

  1. Log in to app.powerbi.com.
  2. Select the workspace where the Deliver instance will be deployed:
    1. Go to Workspace Settings.
    2. Click the Premium tab.
    3. Select the Premium per user or Premium per capacity License mode (this requires a Premium license).
    4. Copy the workspace connection.

      ,m

  3. Go to the Admin Portal.

  4. Under Premium Per User / Dataset workload settings, set XMLA to Read Write.

Note:

If you are using Fabric Capacity to host your endpoint, this setting can be found under Admin Portal > Capacity Settings > Semantic Models > XMLA Endpoint.

Add Power BI Premium Deliver Instance Endpoint

In the Portal, add a Deliver instance and add a Power BI Premium endpoint.

  1. Name: Give your endpoint a friendly name that will appear in Jet Analytics Data Integration.
  2. Server: Paste the Workspace Connection URL copied from the Power BI workspace.
  3. Dataset: This is the name for the Power BI dataset.
  4. Username & Password: The credentials used to log on to app.powerbi.com (i.e. email and password). Alternatively, you can authenticate using a Service Principal — see the optional section below.
  5. Click Save.

Deploying the endpoint in Jet Analytics Data Integration

  1. In Jet Analytics Data Integration, click Refresh to display the newly created Deliver instance and endpoint.

  2. Right-click on the Deliver instance and select Open instance.

  3. Drag the tables from the Prepare instance into the Deliver instance. Right-click on the instance and select Deploy.

Configure the Power BI Data Source Credential

If you receive an authentication error when you first attempt to execute your model, you may need to update your data source credentials.

  1. Go to the Data Model, click the three dots, then click Settings.

  2. Under Data source credentials, select Edit credentials and enter the credentials for the Prepare instance storage.

  3. If you are unable to successfully edit the data source credentials, try taking over the dataset settings first, then edit the credentials.

  4. Go back into Jet Analytics Data Integration, right-click on the Deliver Instance, and select Execute.

Note: If you are using an on-premises SQL Server storage for the Prepare instance(s), you will need to install the Power BI gateway and select this gateway in the Power BI service.

(Optional) Authenticate using a Service Principal

In order for your Deliver instance executions to not be dependent on the credentials of a single individual, you can authenticate to Power BI using an Azure Service Principal or App Registration. Read more about this in Microsoft Docs.

Create an App Registration in Azure

Note: Azure Administrator permissions are required to access Azure Active Directory in the Azure Portal.

  1. In the Azure Portal, navigate to Azure Active Directory. Take note of the Tenant ID — this will be used as part of your username later.
  2. Click App Registrations, then click New Registration. Take note of the App ID — this will be used as part of your username later.
  3. Once the App Registration is created, click Certificate & Secrets, then New Client Secret. Take note of the client secret — this will be used as your password later.
  4. Click API permissions, then Add a permission, and add the permissions shown below.

Allow service principals to use Power BI APIs

  1. Navigate to Power BI Admin Portal > Tenant settings.
  2. Enable the option: Allow service principals to use Power BI APIs.
  3. Under Apply to, select The entire organization. Alternatively, select Specific security groups and ensure the app registration is added to the defined security group.

Give your App Registration Admin Access

  1. In Power BI, open your Workspace.
  2. Click Access.
  3. Enter the name of the App Registration, set the role to Admin, then click Add.

Update Credentials in Deliver instance

  1. Open your Deliver Instance in the Portal and click Edit.
  2. Edit the credentials of your Power BI Premium Endpoint.
  3. Username: Enter the following format:

    app:<appId>@<tenantId>

  4. Password: Enter the following:

    <app client secret>

  5. Click Save.

Was this article helpful?

We're sorry to hear that.