Alright, we now have working tests for our SQL server health; we can customize it to suite the environment. So, what do we do with the data?

Well, dbachecks is a tool designed by data people. People who routinely build reports for their bosses and think in statistics. So, how about exporting the results to PowerBI for better data manipulation and analysis?

Take a look at the following code:

# Import current configuration
Import-DbcConfig -Path C:dbachecks_configproduction_config.json -Temporary

# Run all tests and export data
Invoke-DbcCheck -AllChecks -Show Fails -PassThru |
    Update-DbcPowerBiDataSource -Environment Production

# Start PowerBI with data loaded and dashboard preconfigured
Start-DbcPowerBI