Hopefully the graphic I have added can be viewed.
Essentially I have a source Excel file that is a consolidated piece of work sent to me from an internal security group. It contains AD accounts. I have used the PBI AD data source connector, but for this work I use the excel source as it contains accounts from multiple ‘secure’ domains.
There are some 35 columns in total. One column contains the User account. This is of course pivotal. Another column, contains a series of AD Groups that the account is a member of. This Column is called ‘memberOf’ (Of course it is)!
So for each row containing one User Account there are ‘x’ number of AD Groups that the account could be a member of. For example there could be seven individual AD Groups (ie 7 rows within the one cell) for the one row containing the User Account.
For the example above I need to be able to create 7 rows. ie 7 multiples of the User Account for EACH AD Group. Thus I have called the topic ‘denormalize’.
I hope I this makes sense to my learned PBI colleagues.