microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
307 stars 107 forks source link

PowerBI Price Tab omitting information #950

Open josesarsa opened 2 months ago

josesarsa commented 2 months ago

We are seeing that the PowerBI Cost Summary Report for MCA is trunking the information related to the SKU. In contrast with the SCE is visible all the info to identify the producto charged. You cant tell this in the screenshot below. MCA_contract SCE_contract

flanakin commented 2 months ago

@josesarsa can you share the column name that's being used for each of these screenshots? Is it x_SkuDescription?

josesarsa commented 2 months ago

MCA -> SKU image SCE -> SKU image

flanakin commented 2 months ago

@josesarsa That's just a display name for the table. You can find the actual column name by hovering over the column in the list of columns in the right panel where you add/remove columns. If the tooltip doesn't show up, you can double-click it and delete the custom display name to revert back to the original column name.

Is the toolkit report screenshot with SKU, Commitment, Term, etc. columns something that was customized or is that one of the built-in report pages?

Also, can you clarify what "SCE" is?

josesarsa commented 2 months ago

Is the toolkit report screenshot with SKU, Commitment, Term, etc. columns something that was customized or is that one of the built-in report pages? Yes. Columns are by default.

MCA contract Column name 'CostDetails'[x_Description] SCE contract Column name 'CostDetails'[x_SkuDescripion]

SCE stands for Server and Cloud enrollment if I am not mistaken

josesarsa commented 2 months ago

I updated the finops hub to v0.5 and still the same problem

flanakin commented 1 month ago

Sounds like SCE is the same thing as EA. Does that sound right? What values do you see in the x_AccountType column?

Can you confirm if the MCA column is really "x_Description"? We don't have a column by that name, so if that's what you're seeing, them I'm guessing someone added it. Can you check to see if it's a custom column/measure in the Data panel on the right? If not, can you open the advance query editor for CostDetails and find that column to share what code is used to generate it?

If that doesn't help, we should get on a call. You can email ftk-support@ms to set something up.