20220623 Power BI Developers - Project Sharing

Meeting Details

Date/Time/Location



Attendees

Attendee

Present

Notes

Attendee

Present

Notes

@Eric Johnstone



@Adam Sottosanti (Deactivated)



@Mike Smith



@Mara Morrison



@Ann Crawford (Unlicensed)



@Mark Norstedt



@Amy Pasko



@Kam Kunimoto



Kevin Wu



@Michael Nesbit (Unlicensed)



@Darshan Etz



@Yaheya Quazi



@Santosh Rajput



@Dawn Gregory



@Ankit Chhalotre



@Kara Nowell



@Susan Harris



@Roger Chen



@Diana Antova



@Tedi Tehrani



@Katie Mankins



@Jessica Dewett



@Pam Layton



@Julie Inami



@Lisa Goto



@Alyssa Keehan (Unlicensed)



@Sev Palmer



@Amber Laningham



@Drew Jose



emilysanjuan@ucsb.edu



@Yali Chen

 



Meeting Goals and Expected Preparation

Goals

  • Push the use cases and processes for Power BI

  • Solve any questions if needed.

  • Site Management - Develop comprehensive PBI report to list all items in PBI site - dataflows, datasets, reports, security and automate tasks such as refresh, deployment 

Helpful Preparation

  1. Pull changes in and go to branch firstPBIDev https://github.com/ucsb/ucsb-powerbi

  2. Review your content in PBI usage  Usage Report 

Agenda

Time

Topic

Owner

Time

Topic

Owner

30

Welcome - questions/ problems 

  • sharing what you are working on

Group Discussion 

10

Inventory Report Visuals Review

@Ann Crawford (Unlicensed) @Tedi Tehrani / Group

5

Metrics

Gen 2 App

App Location: https://app.powerbi.com/groups/me/apps/bcaf75d2-86e0-4e5b-814f-6f5cf4ba23ac Workspace Location: https://app.powerbi.com/groups/808da81f-e4d6-4630-8bb0-417c40362382/list

Usage Report 

reminder to check this

Discussion

GitHub Repo

Power Shell Code

Inventory Report

 

 

Future Discussions

 

 Action Items

 Review inventory report to see dataflow description. Update description to dataflows as needed. Group
 @Adam Sottosanti (Deactivated) set up new AD group for users that can see data connections.
 @Ann Crawford (Unlicensed) update power shell scripts with secret parameter.
@Ann Crawford (Unlicensed) code power shell scripts to get dataset > dataflow relationship update report to get dataset > dataflow relationship
@Ann Crawford (Unlicensed) test writing output to csv
@Ann Crawford (Unlicensed) Set up Informatica job server