You may want to see assigned licenses for a specific license within your environment over a certain period of time. The step by step process below explains how to do that.

Note: Our license example is PowerBI, but use which license is relevant to your environment as you go through the steps.

How to create this report

  1. Click Create Report.
  2. Enter a report title, for example Power BI licenses over time.
  3. Click the plus sign to add a section to the report, and a description if desired.
  4. Add a title and description for your section.
  5. Choose the Tenant License History data source under the License Data data source category.
  6. Click table.
  7. Under Select fields, choose:
    • The date of the statistics snapshot
    • License Name
    • Assigned Units
  8. This will then show the amount of licenses you currently have assigned to each license you have within your environment. However, we want to see just the license assignment of Power BI. To do this, we need to click Add filter group.
  9. On Select field, choose License Name.
  10. On Select operator, choose contains.
  11. In Enter filter value, enter Power BI.
    • Note: There are different license types with PowerBI. If you would like to search for a specific license i.e. Power BI Pro, instead of contains in select operator, choose is equal to, then enter Power BI Pro.
  12. Enter your offset and limits (see below).
  13. Sort the date in ascending or descending order, depending on your preference.
  14. Save your report.


Your table should look a little like the one below.

Offset & Limits

Your offset and limits refer to the dates of your table. For example, if you wanted a table representing the previous 14 days, enter 14 into your limits box.

You can go back days, weeks, months or even years depending on your needs.

See other report examples here.

Print Friendly, PDF & Email