1. Titles and Toolbars

    2. Homepage

    3. Curator Styles

    4. Group Overrides

    1. Pages Overview

    2. Tiles

    3. Error Pages

    4. SSRS Embedding

    5. Explorer

    6. User Customized Metrics

    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: Scheduled Reports Option

    3. Report Builder: Email Option

    4. Report Builder: Watermark Text

    1. Automatic License Provisioning

    2. Just-in-time (JIT) Provisioning

    3. Users and Groups

    4. Reset User's Password

    1. Frontend User Permissions

    2. Password Change

    3. Password Reset

    4. Password Expiration and Complexity

    1. E-mail Configuration

    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. Manual Restoration of Curator Backup

    10. Updating Curator Logging

    11. Third Party Cookies

    12. Troubleshooting Load Times

    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.