[PowerBI] Workload Optimization Report (KQL Version) - Error Due to Duplicate Values in 'Resources' Table

[AErmie]

🐛 Problem

When trying to view/load the WorkloadOptimization.kql.pbit file locally (in PowerBI Desktop), the report fails to load due to the error:

Column 'id' in Table 'Resources' contains a duplicate value '/subscriptions/9a330cdf-253b-4489-9c7f-7e805127c58f/resourcegroups/b7ec6b-dev-networking/providers/microsoft.network/privateendpoints/foidocintelprivateendpoint' 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.

When we check our environment, there are multiple Private Endpoints with the same resource name. However, this is supported, as the Private DNS Zones append the environment name to the FQDN value.

👣 Repro steps

TODO: Add repro steps below:

1. Deploy multiple Private Endpoints with the same name (either in the same subscription, or in different subscriptions)
2. Download the latest Workload Optimization report
3. Provide details about the Cluster URL
4. See error

🤔 Expected

Azure itself allows duplicate resource names for Private Endpoints. The query for the Resources table should be updated to accept this scenario.

ℹ️ Additional context

The FTK deployment configuration we are using, is the "private" mode, with an ADX cluster.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.