Developing KPIs

A KPI is an indicator that illustrates the progress made toward a goal. KPIs are great for users who wish to quickly evaluate and monitor the progress made toward a measurable goal.

Note

KPIs are only accessible with SSRS Enterprise edition and Power BI Report Server.

A KPI can be defined manually or based on the first row of a shared dataset. A shared dataset enables you to manage the settings for a dataset separately from reports and other report server items. In the following example, we will walk through the steps required to create a shared dataset using Report Builder. Then, we'll define the KPI in the Power BI Report Server portal:

1. First, open Report Builder.
2. Select New Dataset and browse to the data source you would like to use to create the new dataset. Then, click on Create:
   

   Figure 13.9: A shared dataset is the data source for a KPI in Power BI Report Server

3. Select a shared data source to use for your shared dataset.
4. You...