Azure Consumption Insights - Pricesheet

[Anonymous]

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

[v-juanli-msft]

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]

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