20200806 - Power BI Developers

Owned by Ann Crawford (Unlicensed)
Last updated: Aug 06, 2020
1 min read

Meeting Details

Date/Time/Location


Attendees

AttendeePresentNotes
Eric Johnstone

(tick)


Adam Sottosanti (Deactivated)

(tick)


Mike Smith

(error)


Mara Morrison (Unlicensed)

(error)
Ben Price(error)
Ann Crawford (Unlicensed)(tick)
Mark Norstedt(tick)

Amy Pasko

(error)
Kam Kunimoto

(error)


Yaheya Quazi(error)
Michael Nesbit (Unlicensed)(tick)
Joshua Munsch (Unlicensed)(tick)
Darshan Etz

(error)


Anna Lin (Unlicensed)

(error)


Sonika Sehgal (Unlicensed)

(error)


Sheetal Gupta (Unlicensed)

(error)


Ravi Chauhan (Unlicensed)(error)
amitsaxena@ucsb.edu

(error)


Bruce Miller

(tick)


Anthony Schmid

(error)


Zoe Rousso

(error)


Kara Nowell

(tick)


Susan Harris(tick)
Roger Chen(tick)

Diana Antova

(error)


Tedi Tehrani(error)
Nathan Yee(tick)
Nathan Cook(error)

@Katie Mankins

(error)
@Gajender Singh(error)
Pam Layton(tick)
@Ankit Chhalotre(error)
Julie Inami(tick)
@isiah Fimbrez(tick)


Meeting Goals and Expected Preparation

Goals

  • Push the use cases and processes for Power BI
  • Getting users to use UCSB campus data with Power BI 

Helpful Preparation

  1. Post any questions or issues 

Agenda


TimeTopicOwner
5 mReview use cases and questions in the comments to

All

25 m

walk through moving content to Power BI from SharePoint

Michael Nesbit (Unlicensed)
10 m

New Tools 

Ann Crawford (Unlicensed)
10 m

Questions / Next Steps

All

Discussion 

Michael Nesbit (Unlicensed)showed eop reports and pros and using dashboards - dashboards and mobile do not keep original color when pined to dashboard

Ann Crawford (Unlicensed) showed   to view active directory groups and membership using the native PBI data connector

let
    Source = ActiveDirectory.Domains("my.ucsb.edu"),
    my.ucsb.edu = Source{[Domain="my.ucsb.edu"]}[#"Object Categories"],
    group1 = my.ucsb.edu{[Category="group"]}[Objects],
    #"Filtered Rows" = Table.SelectRows(group1, each ([displayName] <> null)),
    #"Expanded group" = Table.ExpandRecordColumn(#"Filtered Rows", "group", {"groupMembershipSAM", "member"}, {"group.groupMembershipSAM", "group.member"}),
    #"Expanded group.member" = Table.ExpandListColumn(#"Expanded group", "group.member"),
    #"Expanded group.member1" = Table.ExpandRecordColumn(#"Expanded group.member", "group.member", {"departmentNumber", "displayName", "employeeNumber", "employeeType", "givenName", "groupMembershipSAM", "lastLogon"}, {"group.member.departmentNumber", "group.member.displayName", "group.member.employeeNumber", "group.member.employeeType", "group.member.givenName", "group.member.groupMembershipSAM", "group.member.lastLogon"})
in
    #"Expanded group.member1"

Ann Crawford (Unlicensed) showed a few of the new tools accessible from PBI Desktop > Help > New Tools




 Action Items