search

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
309 stars 108 forks source link

Duplicate Values in Workload Optimization PowerBI #1154

Open JAK1047 opened 4 days ago

JAK1047 commented 4 days ago

Refreshing the WorkloadOptimization PowerBI in FinOps 0.6 I get an error on all tables of:

"Load was cancelled by an error in loading a previous table."

Looking down at the Resources section there's an error of:

Column 'id' in Table 'Resources' contains a duplicate value '/subscriptions/SubID/resourceGroups/RGName/providers/Microsoft.HybridCompute/machines/VMName/extensions/AzureMonitorWindowsAgent' 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.

More than likely this was one of our Arc enabled virtual machines that got rebuilt with the same name and had the Azure Monitor Agent extension reinstall. A pretty common situation. Is there any way I can resolve this myself or can logic be added in future implementations to consider this scenario?

flanakin commented 1 day ago

@nteyan Can you look into this?

nteyan commented 1 day ago

@flanakin, I'm working on it.