🐛 Problem

When refreshing the Governance (Storage or KQL) report, I receive the following error:

👣 Repro steps

1. Open governance.storage
2. Fill in required information
3. Select Load
4. See error

ℹ️ Possible Fix

Change the query for Resources to add an extra step to remove duplicates. Here's a working query:

let
query = "
resources
| extend
id = tolower(id),
['sku.name'] = sku.name,
['sku.tier'] = sku.tier,
['provisioningState'] = properties.provisioningState,
['privateEndpointConnections'] = properties.privateEndpointConnections,
['encryption'] = properties.encryption,
['creationTime'] = properties.creationTime,
['supportsHttpsTrafficOnly'] = properties.supportsHttpsTrafficOnly,
['allowBlobPublicAccess'] = properties.allowBlobPublicAccess,
['minimumTlsVersion'] = properties.minimumTlsVersion,
['primaryEndpoints'] = properties.primaryEndpoints,
['keyCreationTime'] = properties.keyCreationTime,
['primaryLocation'] = properties.primaryLocation,
['statusOfPrimary'] = properties.statusOfPrimary,
['networkAcls'] = properties.networkAcls,
['allowCrossTenantReplication'] = properties.allowCrossTenantReplication,
['allowSharedKeyAccess'] = properties.allowSharedKeyAccess,
['accessTier'] = properties.accessTier,
['isHnsEnabled'] = properties.isHnsEnabled,
['isBlueShiftAccount'] = properties.isBlueShiftAccount
" & ftk_DemoFilter(),

// Run the query
Source = AzureResourceGraph.Query(query, "Tenant", null, null, [resultTruncated = false]),

// Remove duplicate ids
RemoveDuplicateIds = Table.Distinct(Source, {"id"})

in
RemoveDuplicateIds