Forum Discussion
Transposing AD extract
Hello, I'm new to PowerBi and new to the community so bare with me. For a report I want to have an overview off alle the people how have acces to a certain folder on a netwerk drive. I got t...
Hey Anonymous ,
Have you tried unpivoting the columns in Power Query?
as in
Select the group column in your AD table --> Unpivot Other columns like shown below:
It will give the data in the below structure which is still efficient to use:
No I didn't try is this way. And I think it might do the trick. Thank you.