> For the complete documentation index, see [llms.txt](https://guides.tability.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://guides.tability.io/docs/become-a-tability-power-user/integrations/power-bi.md).

# Power BI

You can connect Tability to Power BI to automatically pull data for your check-ins without having to switch context.

Once you add Power BI as a data source for an outcome/Key Result, Tability can:

* Pull the most recent value of the metric when you open the check-in form.
* Automatically sync your metric while the plan is active (Premium subscription only).

{% hint style="info" %}
Available on Plus and Premium subscriptions
{% endhint %}

## How to enable the integration

### **Step 1. Upgrade to the Plus or Premium subscription**

You'll need to have a *Plus subscription* to use Power BI as a data source and automatically pull the metric value in the UI for your check-ins.

You'll need to have a *Premium subscription* to enable the sync.

### Step 2. Connect your Power BI account to Tability

1. Go to **Workspace Settings > Integrations**
2. Click on the button **Connect to Power BI**
3. Follow the steps to connect your Power BI account to Tability

## How to add a data source to an outcome/key result

Once Power BI is connected, you will be able to use it as a data source for your outcomes/KRs.

### **Step 1. Open up your edit panel of your outcome/KR**

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FKR9nZnKw6qYogqMG3mvw%2Ffile-bZLSr0JQOb.png?alt=media\&token=89a55e57-058d-4b2d-989b-fc91821b0b83)

Click on "Edit" to open up the Edit panel of any outcome/KR in your workspace.

### **Step 2. Select Salesforce as a data source**

Go to the **Data source** tab and select Power BI as a data source.

<figure><img src="https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FKJybh3CMj5MQTwb5UrMx%2Fimage.png?alt=media&amp;token=337b8e9c-86b8-47ee-b975-6c404e1da865" alt=""><figcaption></figcaption></figure>

### **Step 3. Write your DAX query**

The Power BI integration allows you to write DAX queries to get data from your Power BI account.

You can find various examples of [DAX queries online to help](https://daxstudio.org/docs/tutorials/writing-dax-queries/).

### **Step 4. Save your connection**

Click on "Save & preview" to complete the connection.

Tability will retrieve the current value for that metric and your screen should look like this 👇

<figure><img src="https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FD8wJYuXRvVcysGgF8y1z%2Fimage.png?alt=media&amp;token=6d316a18-d705-454f-9f64-c9602db10695" alt=""><figcaption></figcaption></figure>

You can now toggle the option to Enable auto-sync of your metric if you're on a Premium subscription.

Tability will retrieve the value of your metric from Power BI every other day, and will create a check-in on behalf of the owner of the outcome/KR.

The first data sync should happen within 1h of enabling this option.

## How to use the data source in your check-ins

![](https://318707989-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMULqjSmZyGczPy2I6FGH%2Fuploads%2FtMQNJZIIlkIpiaZCnoP7%2Ffile-oz99rNyaxc.png?alt=media\&token=bf961bf1-330b-4403-8a2e-5f0823fd9739)

It's all automatic! Once an outcome/KR is connected to a data source, Tability will automatically pull the current value whenever you open up the check-in modal.
