One of the questions I get a lot around reporting for SCSM 2012 when using Power BI is how they can pull the Affected User for a Work Item. This sounds straight forward, but it’s really not due to the fact that all of the entities in SCSM are relationship based. Having the Work Item doesn’t mean you have the Affected User right there in front of you.
Today, I’m going to show you how to make that relationship via the Data Warehouse and Power BI to show who your most ‘needy’ users are.
Tech, Finance, and Automation 