Breadcrumbs

Create a Daily Export Report in Azure

Overview

After creating an Azure Storage Account, configure an Azure Cost Management export to automatically generate billing and usage files in the FOCUS 1.0 format.

Yarken recommends using the Cost and usage (FOCUS) export template because it provides a standardized billing dataset with minimal transformation before import.

Once configured, Azure automatically generates billing export files and stores them in your Azure Blob Storage container according to the configured schedule.

Create the export

Note:

Microsoft may take 12–24 hours to generate the first billing export. Depending on your Azure environment and billing data availability, the initial export may take longer.

To create a recurring Azure Cost Management export:

  1. Sign in to the Azure portal.

  2. Search for and open Cost Management.

  3. Select the appropriate Billing Scope.

  4. In the left navigation menu, select Exports.

    Exports-20260716-170634.png

  5. Select + Create.

    Create-20260716-170856.png

The New export page opens. This export page contains the predefined template for exporting cost and usage details using the FOCUS format.

Step 1: Select the export template

  1. Select Cost and usage (FOCUS).

    image-20260716-171006.png

  2. Select Next.

This template exports billing data using the FOCUS 1.0 specification recommended by Yarken.

Step 2: Configure the dataset

On the Datasets tab, configure the following settings.

image-20260716-171614.png
image-20260716-171723.png


Setting

Recommended value

Description

Export prefix

User-defined

Enter a meaningful name for the export. This name becomes part of the exported folder structure.

Dataset version

1.0r2

Uses the FOCUS dataset version supported by Yarken.

Frequency

Daily export of month-to-date costs

Generates an updated billing export each day for the current billing period.

Use a descriptive Export prefix, such as yarken-focus-cost, to make exported folders easier to identify when configuring the Azure Blob Pipeline.

  1. Select Next.

Step 3: Configure the export destination

On the Destination tab, configure where Azure stores the exported billing files.

image-20260716-171830.png

Field

Description

Subscription

Select the Azure subscription that contains the Storage Account.

Storage account

Select the Storage Account created for billing exports.

Container

Select or create the Blob Storage container where Azure stores the exported files.

Directory

Enter the directory path where Azure stores the exported files.

Format

Select Parquet.

Compression type

Select Snappy.

Overwrite data

Leave this option enabled. Azure replaces the previous export with an updated file for the current billing period.

  1. Select Next.

Step 4: Review and create the export

  1. Review the export configuration.

  2. Select Create.

    image-20260716-171921.png

Azure saves the export configuration and schedules the recurring billing export.

Verify the export

After creating the export:

  1. Return to the Exports page.

  2. Confirm that the export appears in the list.

  3. Wait for Azure to generate the first billing export.

  4. Verify that the exported files appear in the configured Azure Storage Account.

Note:

The export configuration is created immediately. However, the first billing file may not be available until Azure completes its scheduled export process.

Result

Azure automatically generates billing and usage files in the FOCUS 1.0 format and stores them in the configured Azure Blob Storage location.

These files are now ready to be imported into Yarken using the Azure Blob Pipeline.

  • Initially, it can take 12-24 hours before the export runs. However, it can take longer before data is shown in exported files.

  • The exported files are stored in a structured hierarchy within the storage folders.

Next step

Related content

Azure configuration

Yarken Pipelines