Key Results from Power BI

Overview

The PowerBI (PBI) Data connector for WorkBoard allows you to pull data directly from the PBI dataset using a DAX Query to automatically update progress of a Key Result. Key Results in WorkBoard will be updated on the next data pull specified by the update cadence. You also have the option of manually completing a real-time data sync. 

Configuring a Data Connector

Prior to setting up a new Key Result data connector, your organization’s IT Administrator may need to approve the connector if there is an approval configuration. Once enabled, any user can have their Key Results measure progress from that specific connector. 

  1. Create a new Key Result by selecting the kebab menu (3 dots) next to the applicable Objective.
    • If the Objective hasn't been created, simply select Create > Team Objective or Personal Objective, then enter your Key Result name.
  2. Select Edit Settings from the dropdown. 
  3. Click Add another key result and enter your Key Result name.
  4. Select Advanced options, then Pull data from external applications. 
  5. Choose the applicable data source from one of the options:Screenshot 2023-07-18 at 11.55.14 AM.png
  6. Log in to the application by inputting your credentials. 
    • Please note that for some applications, you will also need to create an API key or provide OAuth2 information. This information is Read Only. 
  7. Once enabled, your Key Results will automatically update based on the update cadence specified in the Key Result's configuration.
  8. If you need to manually sync an update, use the Sync Integration Data option from the kebab menu (three dots) in the upper right-hand corner of the Key Result details page.

Setting up a Key Result from PowerBI

  1. After completing the steps 1-3 above and logging into PowerBI, click on the Workspace URL dropdown to select a Workspace.
    • Please Note:The Workspace URL dropdown will ONLY display Workspaces you've Viewed.Screen_Shot_2021-10-20_at_6.29.48_PM.png
  2. Choose a Dataset from the dropdown.Screen_Shot_2021-10-20_at_6.30.14_PM.png
  3. Input the DAX query for the data point you are attempting to pull into WorkBoard.
    • Note: Please refer to the "Generating a DAX Query" section below for instructions on how to create a query from the Power BI Desktop app.  Screen_Shot_2021-10-20_at_6.30.39_PM.png
  4. The Verify Data Source button pulls data from the selected Power BI dataset and feed in real-time; this allows the user to cross reference with the data in Power BI to make sure that they have mapped the right data field to the KR.Screen_Shot_2021-10-20_at_6.07.23_PM.png
  5. Click Connect.
  6. Enter the remaining Key Result details, then select an Update Cadence to determine how often WorkBoard will sync to pull the latest value for your Key Result.
    Note: Update cadence has the same options you would find for Key Results updated by a person (i.e., Daily, Weekly, Monthly, and Quarterly).
  7. When finished, select Save to lock in the settings for your Key Result, then Done to apply these changes to your Objective.

Generate a DAX Query 

To generate a DAX query, you need to create a "card" for the data in the Power BI Desktop app.

Screen_Shot_2021-10-25_at_11.07.39_AM.png

From the Desktop app, select the following in order: 

  1. View
  2. Performance Analyzer
  3. Start Recording
  4. Refresh Visuals
  5. Expand Card 
  6. Copy Query

Screen_Shot_2021-10-25_at_11.08.25_AM.png

Once this has been completed, you'll have the DAX query on your clipboard which can be pasted into the DAX Query field in the WorkBoard pop up. 

Synchronize Data from Power BI

WorkBoard will effortlessly sync Key Result updates directly from the data connector based on the specified update cadence. You can manually sync Key Result updates, if needed, in two ways:

Force a Sync on a Single Key Result:

  1. Select Key Result to navigate to the Key Results Details page.
  2. Click the kebab menu (3 dots) in the upper right-hand corner of the page.
  3. Select Sync Integration Data.
    mceclip0.png

Force a Sync for all Key Result Integrations:

  1. From the My Objectives Page, select the kebab menu in the upper right-hand corner.
  2. Select Sync Integration Data.

Frequently Asked Questions

What are the scopes of access that WorkBoard receives when I integrate a Key Result connector?

The scope of access is Read Only, which is bounded by the user integrating with the service.

Will the Key Result connector pull in historic updates?

No, the connector does not have the automated ability to post historic updates to Key Results. The update always goes to the present interval due for the Key Result.

  • Please note that KPI integrations will only deliver updates that are currently due, meaning data pulled in Month X will have the timestamp 'Month X'.
    • As a workaround, multi-target KRs can divide a Key Result into distinct named intervals such as 'August', 'September', 'October', etc. The 'July' interval, for instance, would encompass the start/end dates for data collection (August 1st - August 31st). Despite being named 'July', the data collection would actually occur within the timeframe of August.

When will the connector update my Key Result?

The integration will update based on the update frequency set up for the Key Result (e.g. weekly updates weekly, daily updates daily, etc.). The integration scheduler operates on a twice-daily basis, offering two opportunities for updates to ensure data accuracy. To optimize efficiency, the scheduler skips updates for Key Results (KRs) that are not due for updates, to prevent redundant data updates and maintaining a streamlined process.

How do I grant tenant-wide admin consent (Azure AD)?

Refer to this help document from Microsoft to grant admin consent to an application in Azure Active Directory (Azure AD). 

What if a valid DAX query doesn't work for me?

Check if the right dataset is selected, and that your account has access to the right dataset.

What time does Power BI update each day?

9am PST and 9pm PST.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request