Publish To Power BI Online

1. Overview

This document provides an outline for publishing Centrify 360 Reports to Power BI Online
The reports provided by Centrify 360 are prepared for Power BI Desktop usage and have the following schema:

  • PowerBI

    • SemanticModel

      • Model

      • Report

      • Model.pbip

    • Module 1

      • Report

      • Module1.pbip

    • Module 2

      • Report

      • Module2.pbip
        …​

The Semantic Model is defined once, and linked to each individual module locally.
To publish to Power BI Online, the Semantic Model should be published once, a powershell script should be run to link all modules to the published model, and then each individual report can now be published individually in report-only mode.
This ensures the Power BI Reports are all linked to the same semantic model online, ensuring data consistency across reports.

2. Publish Steps

2.1. Step 1: Publish Semantic Model

Power BI Online - Model

2.2. Step 2: Link Modules to Published Model

  • Navigate to PowerBI

  • Run BindReportsToPBIOnline.ps1 in administrator mode in Powershell, the script takes 2 parameters:

    • RootPath: The path of PowerBI Folder where modules exist (example: C:/Centrify360/PowerBI)

    • WorkspaceName: The exact name of the workspace in Power BI Online

  • The script will prompt for interactive sign-in to Power BI

  • The script will output that the binding was done successfully

Power BI Online - Script Completed

2.3. Step 3: Publish Individual Reports

  • Open each individual report pbir file in Power BI Desktop

  • You should be able to see that the report is already linked to a published semantic model in the bottom right corner

Power BI Online - Model Connected

  • Publish all required reports

  • You should be able to see a single published model linked to all reports in Power BI Online.

Power BI Online - Report Linked

2.4. Next Steps