flanakin / cost-management-powerbi Goto Github PK

Trying the new FOCUS report with an MCA. Errors with statement:

FOCUS
The name 'mf_RetailCost' is already used for a column on table 'FOCUS'. Choose a different name.

CostSummary report works fine.

I'm trying to test this on an MCA and have set both the billing profile ID value & the scope to Billing Profile Id. I'm an owner of the MCA billing account RBAC wise.

Expression.Error: The column 'PricingModel' of the table wasn't found.
Details:
PricingModel

is there something outside the docs that need to be in place?

Hi,

The savings/commitment tabs are not working for MCA accounts. It seems like it is not able to calculate the "OnDemand - If no RI" cost.

Br,
Georg Nesse

Attempting to view the Cost Summary or Commitment PBIX files using MCA Billing Acct ID and Billing Profile ID are leading to the errors attached. (Credentials are valid and work with other functioning PBI reports)

Hello! I'm trying to use the Cost Summary and Commitment Discount templates for an MCA. I'm able to connect with Billing Profile Id, but I get a few Load errors (added screenshot from Commitment Discount). I know the App doesn't work with MCA accounts, but are the other two supposed to?

Hey, I got the following Error after connecting an enterprise agreement.

Data source error: Column 'totalCostWithReservedInstances' in Table 'RI recommendations (single)' contains a duplicate value '17.4407854623408' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: RI recommendations (single).

Is there anything I can adjust on my side?

i have an mca-e agreement and the formula to calculate on demand costs for RI savings is showing me this:

OnDemandCost = if ('CostDetails'[ChargeType]="Usage",'CostDetails'[Quantity]*'CostDetails'[UnitPrice], 0)

However the unit price column comes with 0 for billing events associated to reservations usage:

therefore on demand cost will never be higher then amortized costs.