Extension Statistics Power BI Content pack

Last Update: 6/15/2017

You can gain insight and analyze the progress of your extension by using Extension Statistics Power BI Content pack. All data elements available in the extension hub are also available in Power BI content pack. The content pack contains 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 is not.

Connect to Power BI and get the Content Pack

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

  2. Click Sign In in the upper right corner to log in to Power BI.

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

    If you don't have a Power BI account you can create one by entering your email address and click Use it free.

  4. Click 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 click Get it now.

    connector connector

  6. Enter the Marketplace publisher id for the publisher you want data for and click Next.

    Enter the publisher id used in Marketplace

    Important: Ensure you are logged in power BI using the same credentials you use on the Marketplace and you have access to the Publisher Id.

  7. The next step specifies the authentication method. Only oAuth2 is supported. Click Sign In to continue.

    Login to VS Team Services with oAuth2

    Important: You won't be able to connect if your account 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 account 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 account. Scroll down to the bottom and click Accept.

    VS Team Services Authorization page

  9. Once Power BI is authorized, data will begin to load and you'll be presented with a loading screen until the data is complete. 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 will be downloaded.

Available data and reports

After getting connected you will 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. Details on the extension hub are available here.

The power BI content pack gives 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 high level, data available is:

  1. Acqusition
  2. Uninstall
  3. Rating and review

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

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