search

flanakin / cost-management-powerbi

A set of Power BI reports for Microsoft Cost Management
MIT License
10 stars 3 forks source link

DataSourceError: Duplicate Values #2

Closed lkshck closed 1 year ago

lkshck commented 1 year ago

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?

flanakin commented 1 year ago

This looks like there's a relationship setup on that column.

Go to Modeling > Manage relationships and make sure totalCostWithReservedInstances is not selected: image

For good measure, go ahead and delete that relationship. (It was probably auto-detected.) I've also removed it from the report. Let me know if that fixes it for you!

(And sorry for the delayed response! I've been hyper-focused on FinOps X for the past few weeks.)

lkshck commented 1 year ago

@flanakin Works, thank you!