finops-toolkit icon indicating copy to clipboard operation
finops-toolkit copied to clipboard

PowerBI Price Tab omitting information

Open josesarsa opened this issue 1 year ago • 6 comments

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

josesarsa avatar Sep 02 '24 07:09 josesarsa

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

flanakin avatar Sep 02 '24 11:09 flanakin

MCA -> SKU image SCE -> SKU image

josesarsa avatar Sep 04 '24 07:09 josesarsa

@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?

flanakin avatar Sep 04 '24 14:09 flanakin

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 avatar Sep 05 '24 07:09 josesarsa

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

josesarsa avatar Sep 10 '24 07:09 josesarsa

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.

flanakin avatar Sep 29 '24 17:09 flanakin

Reached out to the requestor offline to see if the issue is still reproducible on v.08.

arthurclares avatar Feb 24 '25 23:02 arthurclares

This is not an issue anymore

josesarsa avatar Feb 25 '25 09:02 josesarsa