I received some requests asking how to include names on the CC reports. By default the reports have only user ids, and I agree only that information is not sufficient to correctly evaluate impact of communications.

There are basically two ways to improve the reports to have names and not only user ids. First one is exporting a list of users from Azure AD (with user ids) and import the file into the Power BI model. Then you can change the report to include user names if you need.

Second alternative involve a change in CC code and is more complex. The prep Azure function can be changed to save additional data about users as part of the synchronization activity.

Well, I’m experimenting with videos now and decided to create one explaining how to extend the sample report we provide as part of the community fork to include user names as well.

How to change the sample report to include user names

Disclaimer – The information contained in this blog post doesn’t represent the official Microsoft guidance or best practices. It is just the view of the author on current alternatives, implementations and workarounds for common issues and/or business needs. Please refer to official Microsoft documentation and evaluate carefully any steps, code or procedures documented herein. The author doesn’t offer any warranty. Use this information at your own risk.