Flexera One's SaaS Management enables Software Asset Managers with the detail required when looking to optimize Salesforce spend across the organization.
Specifically, SaaS Management enables you to:
- Analyze user activity for all your Salesforce instances (orgs) or drill down to a specific Salesforce org
- Understand Salesforce license activity at the rolled-up view for all Salesforce orgs or drilled down to a specific Salesforce org
- Optimize your spend across all of your Salesforce orgs.
To further enhance our capabilities, we have developed a Microsoft Power BI report that provides even more detailed insights into your Salesforce position.
The report, which uses the SaaS Management APIs, was developed in partnership with our customers and product team to ensure that it provides insights that enable improved governance and license management processes for complex multi-org Salesforce environments.
In addition, the Microsoft Power BI report offers a mechanism to provide Salesforce insights to those within your organization who do not use Flexera One's SaaS Management.
To accompany this article, check out this video on Flexera One's Salesforce Power BI reporting for additional details and help with setting up your Power BI report.
Salesforce Commercial Information
The dashboards are preconfigured to calculate spend and optimization potential based on the products you have purchased. In order to obtain optimal value from the Power BI dashboards, we recommend that you add commercial information relating to your Salesforce licenses.
In the Licenses tab of your connected Salesforce org, you can map the user, feature set, or permission set licenses from the Salesforce portal to the actual SKU or product that you have purchased.
In the following screenshot, the Salesforce user license maps against the Sales & Service Cloud - Unlimited Edition (Sales) SKU from the quote.
In the Salesforce Licenses tab, you can also add the Contract SKU Name, the Contact SKU Number (optional) and the Amount (unit price) as listed on the quote for a specific Salesforce org.
Power BI Report Setup
The report, which is attached to this article as a Power BI Template (PBIT), can be easily configured by providing:
- A refresh token is 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.
- Either a single or semi-colon-separated list of the managed application IDs that relate to the Salesforce org(s) that you wish to manage. These IDs are also contained within the URL when you are viewing a particular Salesforce-managed application within SaaS Manager. As an example, when you are viewing the Overview tab of a Salesforce-managed application in SaaS Management, your URL will be in the following format: https://app.flexera.com/orgs/99999/saas/managed-products/987654?tab=overview
- Either a single or semi-colon-separated list of the managed application IDs for your AppExchange discovered applications. This can be obtained in the same way as the ID for the Salesforce-managed application.
- Either a single or semi-colon-separated list of the managed application IDs for your Marketing Cloud managed application; again, this is obtained in the same way as your Salesforce-managed application.
| SaaS Management URL Information Needed for Power BI Reporting | Format |
|---|---|
|
Flexera One Org ID |
999999 |
|
Managed Application ID |
987654 |
|
AppExchange Application ID |
789456 |
|
Marketing Cloud Application ID |
123456 |
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 Salesforce-managed applications you have supplied.
Note: Depending upon the number of managed applications, 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.
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.
on - edited on by
dwampach1
When I download the new file it doesn't automatically prompt for the input data. Once I input the data I keep getting the below errors. I'm only entering Managed Application IDs. Suggestions?
aswindells
Hi @YvonneB - I've just downloaded the PBIT and upon opening, I get prompted for the parameters, as below:
My first thoughts on seeing the error's are that the report is not authenticating, probably caused by you not being able to enter the refresh token and other parameters. Could you try closing down the PBI designer and reopening the PBIT file (downloaded from here) and try again please?
If you still have problems, let me know and we can jump on a call.
Thanks
