Forum Discussion
Responsive ResidentSend an email from Active Dir. list
Hi All,
I got all displays name from my active directory to Power Bi Deskktop
Listed under User Table.
Now I can see list of names.
But I want to send email a report . I can see the names but no email address is listed.
What to do? My goal is to send report thru email. Thanks
Thanks
The email address should be there.
When you expand 'user' make sure you select 'userPrincipalName' in the columns to expand.
3 Replies
- KNP
Super User
The email address should be there.
When you expand 'user' make sure you select 'userPrincipalName' in the columns to expand.
sdhnOnly display name abd distinguished Name columsn are imported.
Rest of ythe columns has Record values.
etc
- KNP
You should be able to expand the records.
Go into 'Transform Data', select the query and expand the user column.