Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Duplicate Values in Workload Optimization PowerBI #1154

Open
JAK1047 opened this issue Nov 22, 2024 · 0 comments
Open

Duplicate Values in Workload Optimization PowerBI #1154

JAK1047 opened this issue Nov 22, 2024 · 0 comments
Labels
Needs: Triage 🔍 Untriaged issue needs to be reviewed Type: Bug 🐛 Something isn't working

Comments

@JAK1047
Copy link

JAK1047 commented Nov 22, 2024

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?

@JAK1047 JAK1047 added Needs: Triage 🔍 Untriaged issue needs to be reviewed Type: Bug 🐛 Something isn't working labels Nov 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Needs: Triage 🔍 Untriaged issue needs to be reviewed Type: Bug 🐛 Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant