Meeting Details

Date/Time/Location

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

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

Pull changes in and go to branch firstPBIDev https://github.com/ucsb/ucsb-powerbi
Review your content in PBI usage Usage Report

Time	Topic	Owner

Time

Topic

Owner

30

Welcome - questions/ problems

Group Discussion

10

Inventory Report Visuals Review

Inventory_3 Site report - comprehensive view of all PBI objects with workspace as the central unit of work.
- review the report - this uses a single API and parses JSON - there is a limit on API calls cannot loop through workspaces
- Fixed issues with ws_HDAE_DistLists - report now shows dataflows, datasets etc.
- The Rest API to get dataset and dataflow relationships returns dataflows that are in a the same workspace as the dataset. How to get other dataflows?
- git repo https://github.com/ucsb/ucsb-powerbi
Clean up
- review the report and clean up old stuff

@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

reminder to check this

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