I’m currently working on a global Active Directory consolidation and Exchange e-mail migration at a client and as with every project is nice/required to report about how the migrations are progressing. At first I was using a PowerShell script that exported all the details that I needed to a comma separated file. The content of the CSV was copied into Excel where I used some Pivot tables to get the actual numbers that I could use in my report.
As you can imagine this took a while to get everything ready (somewhere between one and two hours), so I was eager to find something new where my report was looking better and especially where the whole process was automated. The answer? Power BI! Continue reading “Reporting mailbox migration progress in Power BI”