The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. Click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Flexera One's SaaS Management provides a comprehensive view of your organization's SaaS spend and allows you to quickly and easily identify optimization opportunities.

To further enhance our capabilities and in line with our Microsoft 365 and Salesforce capabilities, we have developed a Microsoft Power BI report that provides you with detailed lenses into your position for any managed application you have in SaaS Management.

The report, which uses the SaaS Management APIs, was developed in partnership with our customers and product team to ensure that it provides the insights that enable improved governance and license management processes.

In addition, the Microsoft Power BI report offers a mechanism to provide insights to those within your organization who do not use Flexera One's SaaS Management.

Power BI Report Setup

The report, which is attached to this article as a Power BI Template (PBIT), can be easily configured by providing:

  • 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), APAC (AU) or Europe (EU)
  • Your Flexera One Org ID, which is a numeric identifier contained within the URL of your org.
  • The managed application ID for the managed application you wish to report on. This is also contained within the URL when you are viewing your managed application within SaaS Management. As an example, when you are viewing the Overview tab of a 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

SaaS Management URL Information Needed for Power BI Reporting

Format

Flexera One Org ID

99999

Managed Application ID

987654

When opening the PBIT file, you will be prompted for these values. For further details, see the following screenshot. After entering these values, your Power BI report will retrieve the data relating to the managed application you have supplied. 

dwampach1_2-1686079419341.png

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.

dwampach1_3-1686079419358.png

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.

Legal Information

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 Power BI 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. 

0% helpful (0/1)
Comments
bharath_malli
By
Level 3

@aswindells : can you kindly check the attachment and make it compatible to the latest Power-BI version please 

aswindells
By Technical Writer
Technical Writer

Hi @bharath_malli - I'm not sure I fully understand your ask here?

I just opened the report in v2.123.684.0 which is the November '23 release of the Power BI desktop designer with no problems.

Please let me know how I can help.

Thanks

Version history
Last update:
‎Aug 19, 2024 01:24 PM
Updated by: