AzureCostManagement.Contents

Updated on

AzureCostManagement.Contents is a Power Query M function that is used to access data. There is currently no additional documentation available.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

AzureCostManagement.Contents(
   scope as text,
   scopeValue as text,
   numberOfMonths as number,
   optional parameters as nullable record,
) as table

Examples

Assuming today is 2017-6-15, get summaries data between 2017-5-1 to 2017-6-15

// Output: Function will return summaries data between 2017-5-1 to 2017-6-15
let
          enrollmentNumber = "100",
          optionalParameters = [ numberOfMonth = 1 ],
          result = AzureCostManagement.Contents( enrollmentNumber, optionalParameters )
      in
          result

Assuming today is 2017-6-15, get summaries data for April 2017.

// Output: Function will return data between 2017-4-1 and 2017-4-30
let
          enrollmentNumber = "100",
          optionalParameters = [ startBillingDataWindow = "-2", endBillingDataWindow = "-1" ],
          result = AzureCostManagement.Contents( enrollmentNumber, optionalParameters )
      in
          result

Assuming today is 2017-6-15, get summaries data from April 2017 till now.

// Output: Function will return data between 2017-4-1 and 2017-6-15
let
          enrollmentNumber = "100",
          optionalParameters = [ startBillingDataWindow = "-2", endBillingDataWindow = "0", dataType = "Summaries" ],
          result = AzureCostManagement.Contents( enrollmentNumber, optionalParameters )
      in
          result

Other functions related to AzureCostManagement.Contents are:

Contribute » | Contributors: Rick de Groot