Making Sense of Data Migration Assistant Assessments with Power BI

The Data Migration Assistant is a great tool developed to assess your SQL Server environment for a migration to a modern SQL Server platform such as SQL Server 2017 or Azure SQL Database. If you’re assessing a single SQL Server with only a few databases, reading the exported results (which can be in .JSON or .CSV format) may not be that difficult. But if you’re assessing dozens of environments including hundreds of databases, we need a better way to understand the results.Recently a customer reached out to me to help with the challenging task of understanding the assessment results of 61 SQL environments including over 500 databases  being considered for migrating to Azure SQL Database. Now there is already a great solution that exists for aggregating DMA assessment exports but it only works for assessment exports in .JSON format. The existing solution also requires that the assessment results be written to a SQL Server database.

So I built a solution that uses Power BI to parse the DMA assessment exports (.CSV format) and aggregate the data so it can be more effectively browsed and understood in a report.

Download the Power BI Template file here

I’ve created a Power BI template file that you can download here to use with your own DMA assessments for migrating to Azure SQL DB. The Power BI template has one parameter used to specify the location of the assessment files. When you open the template file you’ll be asked to specify the directory where the assessments are located. Keep in mind that your assessments should be in a .csv format for use with this template. Also, this template only works for assessments for migrating to Azure SQL DB but I’ll be updating it for assessments to upgrade to modern versions SQL Server.

imageMake sure that the AssessmentDirectory parameter ends with a slash, as seen above. Once you provide the AssessmentDirectory parameter value, click Load and your reports will light up. Below you can see the reports that are included with the template, but you can create any other reports you might need based on the dataset.

imageimageimageimageI hope that you find this useful for simplifying your migration to a modern SQL Server platform. Let me know if you found this useful or if you have a question by leaving a comment down below! Thanks for reading!


Download the DMA Assessment Analysis Power BI template file

Download the Data Migration Assistant to perform a migration assessment of your environment

Download Power BI Desktop

3 thoughts on “Making Sense of Data Migration Assistant Assessments with Power BI”

  1. Great template anyway,

    but “Feature Parity” will only be checked if I move to Azure.

    Thus, if I assess e.g. moving from SQL Server 2012 to SQL Server 2017 the template will produce a lot of errors due to lines like

    #”Filtered Rows2″ = Table.SelectRows(#”Added Index1″, each ([Column1] = “;””Feature Parity”””)),

    in the functions.

Leave a Reply