/reporting

Power BI Azure FinOps FOCUS Reports for CloudMonitor

Apache License 2.0Apache-2.0

About CloudMonitor

CloudMonitor is a revolutionary FinOps tool that enables companies to automate cost governance and proactively reduces cloud consumption and costs.
CloudMonitor consists of 4 seperate reporting areas:

  1. FinOps - Monitor your cloud spend.
  2. Microsoft 365 Analytics - Keep a centralised view of your 365 tenant and users (under development).
  3. Security and Compliance - How well does your organisation adhere to cloud security best practices (under development).
  4. Sustainability - What is your organisations cloud impact from an environmental sustainability and energy consumption perspective (under development).

The CloudMonitor reports are available in this GitHub repository as an open-source resource for you and your organisation to adapt to your specific requirements.

What is FinOps?

FinOps is an operational framework and cultural practice which maximizes the business value of cloud, enables timely data-driven decision making, and creates financial accountability through collaboration between engineering, finance, and business teams.

Learn more at: FinOps Foundation

Looking for CloudMonitor Enterprise?

Click the following link to visit the CloudMonitor website: CloudMonitor

How to connect the CloudMonitor Dataset and Reports

Example using the Power BI FinOps Reports for CloudMonitor.

  1. Download the dataset file "CloudMonitor FinOps Dataset.pbix"
  2. Download required report files e.g. "Executive Summary.pbix" or "Costs.pbix"

Connecting the Dataset in Power BI Service

  1. Open the dataset file and publish it to your target workspace.
  2. In Power BI Service, navigate to the recently published dataset file and go to the dataset settings.
    Service Dataset Setting Dialogue
  3. Under the parameters section, enter the customer ID which was provided to you and apply.
    Service Dataset Settings
    Service Connection Parameter
  4. Under the data source credentials section, click on edit credentials and enter the username and password provided to you.
    Service Edit Credentials
    Service Username and Password
  5. Ensure that you have selected Organizational under the Privacy level settings.
  6. Repeat steps 4-5 for the remaining datasource.

Connecting the Dataset in Power BI Desktop

  1. Open the CloudMonitor FinOps Dataset.pbix file and in the top menu, select Edit Parameters under the Transform Data menu.
    Desktop Edit Parameters
  2. In the dialogue which opens, enter the customer ID which was provided to you and click OK.
    Desktop Parameter Dialogue
  3. From the options and settings menu in the file dialogue, select Data source settings.
    Desktop Options and Settings
  4. In the window which pops up, select one of the datasources and click Edit Permissions.
    Desktop Data Source Settings
  5. In the next window, make sure that Organizational is selected for the Privacy Level.
    Desktop Edit Permission Window
  6. Click on edit under the credentials section and in the following window select the Database option in the left hand menu and then enter the username and password which was provided to you.
    Desktop Credential Window
  7. Repeate steps 4-6 for the remaining datasource.
  8. Once done you may close the datasource settings window.

Connecting the Report Files to the Dataset

Before connecting the report files, you must first publish the Dataset to a Power BI Workspace.

  1. When you open a report file, you will see the following popup mentioning that the report could not connect to a dataset.
    Desktop Unable to Connect
  2. Click on edit, and from the next window select the dataset file which you published to the Power BI Service.
    Desktop Select Dataset
  3. The report will now load and display the following detail in the lower right of the Power BI window, showing which dataset and workspace you have connected to.
    Desktop Connected Live