By providing a single integration to your Microsoft 365 subscription that includes Office 365, Dynamics 365, Power BI, Project and Visio. Flexera One's SaaS Management enables the Software Asset Manager with the detail required when looking to optimize their Microsoft 365 spend across the organization.
To further enhance our capabilities, we have developed a Microsoft Power BI report that provides even more detailed lenses into your Microsoft 365 (M365) position.
The report, which uses the SaaS Management APIs, has been developed in partnership with our customers and product team to ensure that it provides the insights that enable improved governance and license management processes for complex M365 environments.
In addition, the Microsoft Power BI report offers a mechanism to provide M365 insights to those within your organization who do not use Flexera One's SaaS Management.
Setup
The report, which is attached to this article as a Power BI Template (PBIT), can be easily configured by providing:
- A refresh token obtained from your Flexera One org. Details on how to generate a refresh token to work with the Flexera One API can be found in the Flexera One help topic Generating a Refresh Token.
- The location of your Flexera One org using the following options: North America (NA), Europe (EU), or APAC (AU).
- Your Flexera One Org ID, which is a numeric identifier contained within the URL of your org.
- The managed application ID for the M365 managed application you wish to report on. This is also contained within the URL when you are viewing your M365 managed application within SaaS Manager. As an example, when you are viewing the Overview tab of a M365 managed application in SaaS Manager, your URL will be in the following format:
https://app.flexera.com/orgs/99999/saas/managed-products/987654?tab=overview
From the above URL, the Flexera One Org ID and Managed Application ID are as follows:
|
Flexera One Org ID |
99999 |
|
Managed Application ID |
987654 |
- The report provides an overtime tracking of available licenses, active, inactive and never active users and as such requires a date from when this should commence. You can see when you first setup your M365 managed application in SaaS Manager via the integration tab. Enter this date in the following format dd/mm/yyyy for example if your M365 managed application was setup on the 27th of February 2023 you will enter 27/02/2023.
When opening the PBIT file, you will be prompted for these values, after which your Power BI report will retrieve the data relating to the M365 managed application you have supplied.
Note: Depending upon the size of your user and activity data, the report may take some time to load.
You may also see the following message, which can be dismissed using the 'Discard Changes' option.
Once you have configured the report, you can then publish it to your Power BI service, allowing the report to be shared within your organization. You can also set a refresh schedule ensuring that the data you see within your report is up to date.
Note
Reports are provided on an "as is" basis. neither Flexera nor its suppliers make any warranties, express or implied, statutory or otherwise, including but not limited to warranties of merchantability, title, fitness for a particular purpose or noninfringement. You shall be responsible for the procurement of any third party license rights necessary to use the Reports, including without limitation appropriate PowerBI license rights. For the avoidance of doubt, Flexera shall retain ownership of all rights, entitlement and interest in and to the Reports. Reports shall be deemed Confidential Information of Flexera and shall not be used by or disclosed to any third parties except as necessary to use the Reports in conjunction with your current license grant for SaaS Management.
