1. Curator Styles

    2. Homepage

    3. Titles and Toolbars

    4. Group Overrides

    1. Pages Overview

    2. Tiles

    3. SSRS Embedding

    4. Explorer

    5. User Customized Metrics

    6. Error Pages

    1. Tutorials

    2. Search

    3. Managing Menus

    4. Menu Items

    5. Keywords

    6. Files

    7. Notices

    8. Loading Screens

    1. Embedded Tableau Server Views

    2. Thumbnails

    3. Tagged Workbooks

    4. Favorites

    5. Email Subscriptions

    6. Data Export

    7. Download Workbook

    8. Share Workbook

    9. Custom Views

    10. Pause/Resume Changes

    11. Dashboard Titles

    1. Filters

    2. Parameters

    3. Apply Button

    4. Filter Categories

    5. Hidden Sticky Filters/Parameters

    6. Specify Filter Sheet

    7. Mark Commenting

    8. URL Action Overrides (Link Target)

    9. Hidden Dashboards

    10. Replace Dashboard URLs

    11. Site Switcher

    12. Cache Filter/Parameter Options

    1. Data Manager Basics

    2. Web Data Connector (WDC)

    3. Connecting to Data Manager

    4. User Commenting

    5. Field Calculations

    1. Overview and Enabling

    2. Report Builder: Email Option

    3. Report Builder: Watermark Text

    4. Report Builder: Scheduled Reports Option

    1. Automatic License Provisioning

    2. Just-in-time (JIT) Provisioning

    3. Users and Groups

    4. Reset User's Password

    5. User Sync and Membership Sync Overview

    6. Custom Attributes

    1. Frontend User Permissions

    2. Password Change

    3. Password Reset

    4. Password Expiration and Complexity

    5. Bypass Link-preview Security

    1. E-mail Configuration

    2. System Notifications

    1. Force SSL

    2. Trusted Tickets

    3. Basic HTTP Authentication

    1. Import / Export

    2. Backend Users

    3. Frontend Users

    4. Updating License Key

    5. Linux: Cron Troubleshooting

    6. Filesystem Permissions

    7. Backend Administrator Password Reset

    8. Dependency Updates

    9. Updating Curator Logging

    10. Third Party Cookies

    11. Troubleshooting Load Times

    12. Manual Restoration of Curator Backup

    13. Curator Backup

    14. Taking a Manual Full Backup

    1. System Upgrade

    2. Disable Curator Upgrades

    3. Offline Upgrades (Airgapped)

    4. Troubleshooting Upgrades

    1. Scripts

    2. Commands

    3. Subscription Routing

    1. Curator API Overview

    2. Integration

    3. Curator API

    4. Tableau API

    5. Content

    6. User API

    1. Username Mapping

Setup: Power BI Connection

Service Principal Setup

Create a Service Principal with Password

A service principal is needed to query your Power BI tenant to get lists of dashboards and reports, which aid in easily publishing those elements to Curator. These APIs are only available to master accounts and service principals. A service principal is needed to avoid Multi-Factor Authentication (MFA) that may be configured with your master account.

To create a service principal, you’ll need to run the following commands in PowerShell:

  1. Install-Module AzureAD
  2. Connect-AzureAD
  3. $sp = New-AzureAdServicePrincipal -Display <Your Desired SP Name Here>
  4. New-AzureADServicePrincipalPasswordCredential -ObjectId $sp.ObjectId -Value <Your Desired SP Password Here>

If you run into permissions errors, you may need your system administrator to run these commands.

Note: You can also set other details, such as start and end dates, for the service principal account and password by using various PowerShell command parameters.

Add Service Principal to Power BI Workspace(s)

In order for the service principal to have access to your Power BI content, it must have permissions to the Power BI workspace(s) you intend to use with Curator.

To add access:

  1. Log in to the Power BI portal (https://app.powerbi.com)
  2. In the left navigation, click on “Workspaces”.
  3. Hover your mouse over one of the workspaces and click on the 3 dots that appear on the right. Choose “Workspace access”.
  4. Search the service principal name and give it the "Admin" permission. This ensures Curator will have access to add any content from Power BI that your Curator admins would like to add.
  5. (optional) Repeat the process for any remaining workspaces that need access.