Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Extend the Azure consupmtion data.

Hi,   I am pretty new to Power BI and need some help on extending the time that Power BI keeps the data it collects, specifically from the Azure consuption API. I have read the article published be...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

Actually, official document has shared the power query formula to modify load data with filters parameters.(bold part)

let    
    enrollmentNumber = "100",
    optionalParameters = [ numberOfMonth = 6, dataType="DetailCharges" ],
    data = MicrosoftAzureConsumptionInsights.Contents(enrollmentNumber, optionalParameters)   
in     
    data

After finish get data steps, please enter to query editor and modify your query to as above, and modify bold part number to control have many months to load.

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous

Hi! Just to be clear, what is the default number of months of data that Power BI desktop pulls if I did not configure this?