Script to show how to get a row count for tables in a SQL Server database.

RowCountAll.ps1

$DatabaseParam = @{
    SqlInstance = 'localhost\SQLDEV2K14'
    Database = 'DMODisabled'
}
Get-DbaDatabase @DatabaseParam |
    Select-Object -ExpandProperty Tables |
    ForEach-Object -Process {
        [PSCustomObject]@{
            Name = $_.Name
            RowCount = $_.RowCount
        }
    }