Azure peek dashboard - new customers not appearing

[katomel4]

I have notist one issue at the Azure peek dashboard New customers (less than a month) with Azure subscriptions are not appearing in the Dashboard. Nor in the azure sql database as well New subscriptions for old customers are appearing at the dashboard

For these new customers (less than a month), I checked and see money consumption in the CSP Portal May be the Azure CSP reflect these new customers for the Peek only after a true billing accrue? At the beginning of the month?

10x

[snpdev]

Hi katomel4,

From what I see, the CspBillingData and CspSummaryData only contain data for invoiced consumption. So, related PowerBI reports won't display data until after the billing period has closed.

The CspUsageData table only contains data for consumption not yet invoiced. However, this table aggregates QuantityUsed by ResourceId for each SubscriptionId. Since CspUsageData does not have a rows for daily usage (unlike CspBillingData), it is not evident through what date the consumption is aggregated. I see a latency in the update of this table relative to the CSP portal, but have not determined the duration of the latency.

What is your experience since the date you first posted this issue?

[s3banerjee]

Hi Snpdev,

My understanding is also same that CspBillingData and CspSummaryData contain data for invoiced consumption.

CspUsageData table contains data for the coming billing period.Though i was running from last 3-4 days there is no change in the column Sum (value) for QuantityUsed and TotalCost of the CspUsageData , that too for client/customer who are using csp portal heavily.

Any views /comments please.

Thanks,

Saurabh

[katomel4]

only after the billing period I get to see the new customer in the history billing report. not yet in the cuurent billing report