AzGraphtoStorageTable.ps1

$storageTable = (Get-AzStorageTable -Context $storageContext -Name $storageTableName).CloudTable
$resources = Search-AzGraph -Query 'where type !in ("microsoft.compute/virtualmachines/extensions", "microsoft.compute/restorepointcollections", "microsoft.portal/dashboards")| project id, name, location, resourceGroup, properties.storageProfile, properties.hardwareProfile, type' -First 2000

foreach ($res in $resources) {
    $properties = $res.PSObject.Properties
    $tableEntry = @{}
    foreach ($prop in $properties) {
        if ($prop.value) {
            $tableEntry.add($prop.name, $prop.value) 
        }
    }
    $null = Add-AzTableRow -table $storageTable -partitionKey 'westeurope' -rowKey $res.id.replace('/','') -property $tableEntry -UpdateExisting
}