Extension Statistics Power BI content pack

  • 2 minutes to read

Azure Boards | Azure DevOps Server 2019 | TFS 2018 | TFS 2017 | TFS 2015

Gain insight and analyze the progress of your extension by using Extension Statistics Power BI content pack. All data elements in the extension hub are also available in Power BI content pack. The content pack has a complete analytic data model, (tables, relationships, and measures), a set of default reports, and a default dashboard. Reports and dashboards are fully customizable, but the data model isn't.

Connect to Power BI and get the content pack

  1. Open a web browser and go to https://powerbi.com.

  2. Choose Sign in in the upper right corner to sign in to Power BI.

    If you don't have a Power BI account you can create one by entering your email address and choosing Start free, and then Download free.

  3. In the lower left corner, select Get Data.

    Power BI get data

  4. Select Get under Services on the Get Data page.

    get-data-final.png

  5. Search for Marketplace and select the Visual Studio Marketplace Extension Statistics and Get it now.

    connector connector

  6. Enter the Marketplace publisher ID that you want data for, and then select Next.

    Enter the publisher ID used in Marketplace

    Important: Sign in to Power BI using the same credentials you use on the Marketplace, and you have access to the Publisher ID.

  7. Specify the authentication method. Only oAuth2 is supported. Choose Sign in to continue.

    Sign in with oAuth2

    Important: You can't connect if your organization administrator disabled third-party application access via OAuth. When enabled, it appears as follows on the Administration > Control panel > Settings page:

    Third-party oAuth enabled

    Contact your organization administrator to determine if it needs to be enabled.

  8. Successful authorization displays the following authorization dialog, which allows Power BI to retrieve data from your organization. Scroll down to the bottom and select Accept.

    Azure DevOpsAuthorization page

  9. You're presented with a loading screen until the data is loaded. Depending on how much data there is, it may take a few minutes to complete the data load. All extension data associated with this publisher is downloaded.

Available data and reports

Once you're connected, you see an initial dashboard with details on all of your extensions. All data available in the Marketplace extension hub is available in the content pack. For more information about the extension, see Extension reporting hub.

The Power BI content pack provides data for all extensions and you can use the filters to view data for an extension or use the extension report to compare data between extensions.

At a high level, the following data is available:

  1. Acquisition
  2. Uninstall
  3. Rating and review

Using the report and available data elements, you can create your required reports and pin them to the dashboard.

To get started using Power BI, see the knowledge base of articles.