Page History

...

You can use the License Statistics API as input to Power BI; for example, to create a custom report. The steps to use the License Statistics API with Power BI include: 

1. Creating Create a token with API scope.   in License Statistics
2. Add Adding a Web data source to Power BI
3. Prepare the License Statistics API data Create a reportfor use with Power BI  
4. Use the prepared License Statistics data to create a Power BI report

These steps are detailed below.

Create a token with API scope

In order to make API requests, you must use a token, as described in detail in Making an API request. When creating the token, choose to create one with API scope.Image Removed

1. Go to API under your logged in username, shown in the upper right corner of the application window.
2. Click Add to create a new API token.

3. From the dialog that opens, choose API as the scope type for the token.
   
   Image Added
   

4. Optionally, add a description to identify the token.
5. Click Save to create the token.

After you save your new API token, you'll see it in the API Tokens grid.

...

Add a Web Data Source to Power BI

In the Power BI Desktop, create :

1. Create a new report

...

1. .
2. From the "Get data" menu, select Web as the data source.
   
   Image Modified
   
   
3. Complete the form that displays.
   
   Image Added
   
   
   1. Use the Advanced option to add API endpoints. For our example,

...

1. 1. we'll use the "/api/v2/feature/{id}/usage-history/json" endpoint. 
   2. The Feature ID (set to 60 in our example) can be retrieved by using the "/api/v2/feature/list" endpoint or

...

1. 1. by looking at the Feature ID column on any grid in the License Statistics UI, as shown in the illustration below. (The Feature ID column is hidden by default, so you may need to toggle its visibility on.)
      
      Image Modified
      
      
   2. Set the query parameters; for example, you might set a start date of December 6, 2022, and an end date of December 11, 2022:
      
      1. sd=2022-12-06
      2. ed=2022-12-11
      3. granularity=DAY
         
         Image Added
         
         For a complete list of optional API endpoint parameters see API endpoints.

...

1. 1. 1. 
         

   2. Add the appropriate HTTP request headers:

      1. Accept: */*
      2. X-Auth-token: {API token value}

...

1. 1. 1. 
         
         Image Modified
         
   2. Click OK to accept the completed form. 
2. When

...

1. prompted, use the Anonymous access option. Authorization has

...

1. been handled by the token we added to the header in the previous step.
   
   Image Modified
   
   

2. Click Connect to access the defined Web source and get the requested data.
   
   Image Added
   

Prepare the data

The data that Power BI receives from the License Statistics API must be formatted before you can read it. Image Removed

1. Click List to navigate to the data key details.  
   
   Image Modified
   
   
2. Convert the list of records to a table using the "To Table"

...

1. option.
   
   Image Modified
   
   
2. The results appear as shown below.
   
   Image Modified
   
   
3. The resulting Table of records can be expanded to include multiple columns. Select the fields from the response that are needed for your desired report. (Note: You can also set a list of returned columns using the fieldsVisibility request parameter.)
   
   For our example, we'll choose the following fields:

   1. lud (date)

   2. 
      

      lumin (min used)

   3. 
      

      lumax (max used)

   4. 
      

      ft (total)
      

Note: You can also set a list of returned columns using the fieldsVisibility request parameter.

1. 1. 
      Image Modified
      
      
2. The table will be expanded to a multi-column view.
   
   Image Modified
   
   Note: See API endpoints for a full list of parameters along with descriptions.
   
   Image Modified
   
   
3. For proper processing, define the type of data for each column. In our example, the lud property is a Date type, while the rest of the properties are Whole Numbers.
   
   Image Modified
   
   
4. Rename the columns so they will be understandable in the reports.
   
   Image Modified
   

Create a

...

report in Power BI using the License Statistics data

Once you have prepared the data source, you can use the data to create your custom report. For example, you could create a usage history report for a particular feature that includes maximum usage, minimum usage, and the total number of licenses used daily during a selected period of time. 

...