Azure consumption insights returning only 13 months data even with 36 months in the query

[mrcr]

Hi all,

i am using Azure consumption insight connector to get our Azure tenant usage.

but even i have specified to get 36 months data (numberofmonths=36) in the query . Power BI only bring 13 months data.

any idea?

[v-piga-msft]

Hi @mrcr ,

Have you solved the problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @mrcr ,

From the docuement, we'd better get no more than 12 months of data to avoid thresholds with import constraints and the volume of data allowed for queries in Power BI.

Please check if you hit the limitations below:

When working with reports and creating queries, use the following:

• To define the number of months starting from the current date, use numberOfMonth
  • Use a value between one and 36 to represent the number of months, from the current date, you want to import. We recommend getting no more than 12 months of data to avoid thresholds with import constraints and the volume of data allowed for queries in Power BI.
• To define a period of months in a historical time window, use startBillingDataWindow and endBillingDataWindow
• Do not use numberOfMonth together with startBillingDataWindow or endBillingDataWindow

Best  Regards,

Cherry