20220512 Power BI Developers - Site Mgmt.; Rest APIs
Meeting Details
Date/Time/Location
May 12, 2022
Location: https://ucsb.zoom.us/j/223753798
9:00-10:00
Attendees
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 | ||
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
Create a github account and see if you can access https://github.com/ucsb/ucsb-powerbi
Review your content in PBI usage Usage Report
Agenda
Time | Topic | Owner |
---|---|---|
5 | Welcome - questions/ problems | Group Discussion |
5 | 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:
| @Amy Pasko, @Mike Smith, @Mark Norstedt |
5 | Metrics 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 | 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