[Cost Management] FOCUS ServiceName is missing in some scenarios

[flanakin]

🐛 Problem

FOCUS ServiceName is empty for the following scenarios:

• Marketplace purchases (EA)
• Savings plan purchases (MCA)
• Rounding adjustments (MCA)
• Reservation purchases (MCA)
• MACC shortfall (MCA)
• Azure credits (MCA)

👣 Repro steps

1. Export FOCUS data from Cost Management
2. Filter rows where ServiceName is empty

🤔 Expected

ServiceName should have a value

ℹ️ Additional context

The following query identifies known scenarios:

Costs
| where isempty(ServiceName)
| project-reorder ChargeCategory, PublisherName, x_PublisherCategory, CommitmentDiscountType, x_SkuDescription, SkuId, SkuPriceId, x_SkuDetails, x_SkuServiceFamily, x_SkuMeterCategory, x_SkuMeterSubcategory, x_SkuMeterName
| extend scenario = case(
    ChargeCategory == 'Purchase' and x_PublisherCategory == 'Vendor', 'Marketplace purchase',
    ChargeCategory == 'Purchase' and isnotempty(CommitmentDiscountType), strcat(CommitmentDiscountType, ' purchase'),
    x_SkuDescription in ('RoundingAdjustment', 'Azure credits', 'MACC Shortfall'), x_SkuDescription,
    ''
)
| summarize count(), max(ChargePeriodStart) by scenario, x_BillingAccountAgreement | order by count_ desc

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Are there any additional scenarios that you are seeing ServiceName empty in FOCUS data?
3. Leave comments to help us solidify the vision.

[lundejd]

I don't know if this is related but it seems so, the post is too vague to be sure. I started trying CostSummary.storage.pbit today and immediately got errors that SkuMeterName (and x_InvoiceID after I deleted the SkuMeter entry) at least were not found. I was able to move forward by nuking the following steps: InvoiceID, SkuMeter, Align12

I am using FOCUS 1.2-preview. I can see InvoiceID but they are all null from what I can tell. x_SkuMeterName, SkuMeterName and x_InvoiceID are not there. We have an EA.