Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Azure Consumption Insights - Pricesheet

Hi all,

 

I am trying to pull around 1 year (past) data of pricesheets. But it seems like it can only get the current month or 2 months ago (why can I not get the previous month?). And another thing is that I need to pull each pricesheet separately (1 month at a time).

 

There are my power bi queries:

#Current month
let
    enrollmentNumber = "???",
    optionalParameters = [ startBillingDataWindow = "-1, endBillingDataWindow = "0", dataType = "PriceSheet" ],
    pricesheets = MicrosoftAzureConsumptionInsights.Contents(enrollmentNumber, optionalParameters)
in
    pricesheets
#2 months ago (I don't know why it skips previous month?)
let
    enrollmentNumber = "???",
    optionalParameters = [ startBillingDataWindow = "-2", endBillingDataWindow = "-1", dataType = "PriceSheet" ],
    pricesheets = MicrosoftAzureConsumptionInsights.Contents(enrollmentNumber, optionalParameters)
in
    pricesheets

etc...

 

Anyone have any clue how to get 1 year worth of pricesheets in one big dataset instead of one month worth datasets as well?


Cheers

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Does your dataset include all years' data or data of only current year?

    Which column do you apply the parameter?

     

    Could you show an screenshot here?

     

    Best Regards
    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Maggie,

       

      I found a workaround to another dataset but those queries were only giving me 1 month worth of data everytime. If I modified the billing window variable to a bigger one, it would just give me the currrent month's data regardless.

       

      If there are no quick solutions, that's fine but if you have anything else to add to the issue I had, I'll be glad to hear it!

       

      Thanks,
      Jack