In this article, we will review how to configure the PPM Express Governance Power BI pack.
Note, that you need a registered Power BI account in the Power BI service.
Before you proceed to the steps below, make sure you have the following:
- Computer with an Internet connection.
- PPM Express Governance report pack. Download the Governance report pack from PPM Express Settings -> Reporting.
Note: The setting is available only to users with the 'Administrate app' permission in PPM Express. PPM Express user permissions are managed via the People Management section.
- Registered Power BI account in the Power BI service.
Governance report pack configuration
To configure the PPM Express Governance Report Pack, perform the following:
1. First, publishing or uploading the downloaded report to Power BI Service is required.
The report can be added to Power BI Service either using the Power BI Desktop app or via Power BI Service. Please select the way that works better for you:
- Open the downloaded file in Power BI Desktop and publish it. For instructions on how to publish Power BI reports, please refer to Microsoft documentation.
- Open Power BI Service, navigate to the required workspace, and select Upload => Browse a file.
2. After publishing/uploading the report, we need to configure its Semantic model (former dataset).
For this purpose, we will open PPM Express => Reporting settings first.
PPM Express has an open protocol that allows querying data - PPM Express OData.
Navigate to the PPM Express Report Settings page. In the Report Settings, you can find the OData feed URL – this is a URL link to PPM Express instance OData that you can use to connect to PPM Express OData.
Copy the URL from the OData feed URL field.
3. Open the Power BI service, open the Workspace where you have published the report, navigate to the published Semantic model (former dataset), click on the ellipsis button, and choose Settings.
4. On the Settings for the published Semantic model (former dataset) page, open the Parameters section and paste the OData URL to the PPMExpressODataUrl parameter.
Click Apply.
5. Return to the PPM Express Report Settings page.
To be able to create reports, a password is required. In PPM Express, you can create a token, that can be used as a password.
To create a token for a report, perform the following actions:
Click Create access token under the OData feed URL.
Click the Generate Token button.
Copy the token.
Make sure you copy the above token now. We don't store it, and you will not be able to see it again.
Copy the created token and switch back to Power BI Settings for the PPM Express page.
6. Open the Data source credentials section and click the OData => Edit credentials link.
Configure PPM Express Governance Report Pack menu will appear.
Paste the token copied from the PPM Express Report Settings page to the Password field.
Fill in the User name field.
Please make sure to select a Basic Authentication method. Click Sign in.
7. Next, we need to establish a connection to the Web. By establishing a connection to the Web, we ensure that the latest version of the report pack will be available for download.
Click on the Web => Edit credentials link.
Select an Anonymous authentication method and Organizational privacy level. Click Sign in.
8. It is recommended to set up the Automated Data Refresh at once so that the latest data is displayed for the report. For this, click Scheduled Refresh in the Settings for PPM Express.
In the Keep your data up to date section, toggle the switch to On.
You can also choose the Refresh Frequency, Time Zone, and Time when the refresh will occur.
Click Apply once you are done.
Also, it is required to launch data synchronization for the report at once, so it starts displaying data for the report. For this purpose, open the Workspace where you have published the report, navigate to the published Semantic model (former dataset), and click the Refresh button.
