20220512 Power BI Developers - Site Mgmt.; Rest APIs

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



@Nathan Yee



@Katie Mankins



@Jessica Dewett



@Pam Layton



@Julie Inami



@Lisa Goto



@Alyssa Keehan (Unlicensed)



@Sev Palmer



@Amber Laningham



@Drew Jose



emilysanjuan@ucsb.edu





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. Create a github account and see if you can access https://github.com/ucsb/ucsb-powerbi

  2. Review your content in PBI usage  Usage Report 

Agenda

Time

Topic

Owner

Time

Topic

Owner

5

Welcome - questions/ problems 

Group Discussion 

5

Site Management

  • inventory - use to create a pbi report of all pbi entities. This will help standardize, eliminate duplicate code and help users find what is needed

  • automate tasks such as refresh, deployment 

  • Power BI - Site Management



Group Discussion

10

GitHub Repo

Make sure you can access the repo - you will need a github account which takes about 5 minutes to make

https://github.com/ucsb/ucsb-powerbi



Group discussion

25

Review prototype power shell script

Site Inventory Report will be developed using the following tools:

  • Power Shell -environment setup 

  • @Mark Norstedt has a prototype power shell script for getting all access for graddiv workspaces.  We will review and see how to make this generic for the PBI site.

  • PBI Rest APIs

  • VS Code

  • @Amy Pasko or @Mike Smith bring an example of a power shell script comments for a template for the



 @Amy Pasko@Mike Smith, @Mark Norstedt

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 

all

Discussion

@Kara Nowell -  save a bookmark in google chrome to an app url >then update the app with a new version of a report in the app > click on saved app bookmark > it will bring up the old version of the report.  Expected behavior is to see the new version of the report.  No one in the meeting had an explanation but noted that the booked marked url was different than the url gotten by switching pages in the app and then going back to the bookmarked page. 

@Mark Norstedt - showed his powershell for getting workspaces using cmdlet Get-PowerBIWorkspace.  To return all site workspaces, run the command as Get-PowerBIWorkspace -Scope Organization and run as a site admin, e.g. sist-datagw@ucsb.edu

@Mike Smith - showed various power shell scripts with documentation and how to configure power shell environment.  The scripts are in the ARIT git organization. Some of this code will be added to the the power bi repo.   The screen shot below is an example of code and comments at the top of the script for configuring the power shell environment.





Future Discussions



 Action Items