Skip to main content

Creating Scheduled Exports (Preview) in the Azure Portal

note

This step is required only if you are using Exports.

In the Azure Portal, scheduled exports must be in one-month chunks and can go back up to a maximum of 395 days.

Exports enable you to create a recurring task that automatically exports your billing data to an Azure Blob Storage on a daily, weekly, or monthly basis. The exported data is in CSV format and contains all the cost and usage data.

You can export large amounts of data with exports from Cost Management and import it into Flexera One.

To export data in the Azure storage account for importing it into Flexera One for cost reporting purposes:

  1. Sign in to the Azure portal (portal.azure.com ) using your Azure account.

  2. In the upper-left corner of the Web page, click the Show portal menu icon, and then click Cost Management + Billing.

  3. In the left pane, expand Settings, and then click Exports.

  4. Click Create to create a new billing export. The New export page opens.

  5. In the Basics tab, select the Create your own export tile. The Datasets tab opens.

  6. In the Datasets tab:

    1. Click Add export. The Add export page opens.

    2. From the Type of data dropdown list, select one of the following options.

      note

      You must create two exports—one for each type. Repeat steps below for each export type.

      • Cost & usage details (actual)—To export standard usage and purchase costs.

      • Cost & usage details (amortized)—To export amortized costs for purchases such as Azure reservations and Azure savings plan.

    3. In the Export name field, enter the name for your export.

    4. From the Dataset version dropdown list, select the dataset version. For Azure MCA, only versions 2021-01-01 and 2021-10-01 are supported. It is highly recommended to use the 2021-10-01 version.

    5. From the Frequency dropdown list, select Daily export of month-to-date costs so that the latest data is aggregated from the previous daily exports.

      note

      It is recommended to use the Daily export of month-to-date costs option.

    6. Click Add. In the Datasets tab, enter the Export prefix.

    7. Click Next. The Destination tab is enabled for you to define the export destination.

  7. Enter information in the Destination tab.

    1. From the Storage type dropdown list, select the storage type. The default type is Azure blob storage.

    2. In the Destination and storage section, choose the Use existing or Create new option, and enter information of your Azure storage account subscription.

    3. From the Subscription dropdown list, select your Azure storage account subscription.

    4. From the Storage account dropdown list, select the storage account name or create a new one. If you create a new storage account, choose an Azure region.

      info

      If you are setting up a new storage account in the Azure portal, you must assign the Storage Blob Data Reader role to the storage account to access the blob data. For instructions, see Assigning Permission to Azure Storage Account.

    5. In the Container and Directory fields, enter the storage container and directory path for the export file.

    6. From the Format dropdown list, select CSV.

    7. From the Compression type dropdown list, select None as compressed files are not supported.

    8. If you want to split your exports into multiple smaller files, enable the File partitioning option. This option is enabled by default. It is recommended to keep it enabled.

    9. Choose whether to enable the Overwrite data option. This option is enabled by default. When enabled, daily exports replace the previous day's file with an updated file.

    10. Click Next. The Review + create tab is enabled.

  8. Validate the export configuration and click Create. Your new export appears in the list of exports.

  9. Finally, create the export URL to connect a Bill Connect in Flexera One. The URL should be in the following format.

    https://<storage-account>.blob.core.windows.net/<container-name>/<directory-path>/<export-name>
tip

For information on creating and managing exported data, see Microsoft's documentation on Improved exports experience - Preview.

Seeding Data for Older Months​

You don't need to create multiple exports with different names for each month. You only need two exports—one for amortized and one for unamortized. You can always edit the existing exports.

note

This simpler method of seeding data only supports the improved Azure Exports (preview). If you have not enabled the improved Exports (preview) in Azure Portal, you need to use the Exports API to seed old data.

To seed data for older months:

  1. Go to the Exports page and click the export you created in Creating Scheduled Exports (Preview) in the Azure Portal.
  2. In the Export selected dates section, select the Start and End dates. The Start date should be the first day of the month, and the End date should be the last day of the same month. For example, "03/01/2024" and "03/31/2024" can be selected as the start and end dates, respectively.
  3. Click Execute.
  4. Repeat steps 1 to 3 for the other months that you want data for.
  5. Repeat steps 1 to 4 for both the amortized export and the unamortized export.
note

Compressed exports in the gzip format which are created from Exports API are not supported.