/
20220505 Power BI Developers - Site Mgmt.; Rest APIs

20220505 Power BI Developers - Site Mgmt.; Rest APIs

Meeting Details

Date/Time/Location


Attendees


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

TimeTopicOwner
5Welcome - questionsGroup 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 
  • /wiki/spaces/PB/pages/17138876539


Group Discussion
10

Review/Restructure GitHub Repo

suggestions for managing code

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
  • 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


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

  • Users will need access to the PBI repo.
  • The creation of the report will focus on creating the data using power shell and rest apis.  Users that are adept at visualization will craft the report from the data. 
  • Reviewed the power shell example provided by Mark Norstedt
  • Reviewed the structure in git repo https://github.com/ucsb/ucsb-powerbi. Amy Pasko and Eric Johnstone proposed the following folder structure
    • Add a folder for each of the PBI Artifacts: Data Sources, Reports, Workspaces, Data Flows, Gateways, Apps, Licenses, Groups
    • Add folder called "Code" under each Artifact
    • Add folder for a given code base as needed. e.g. PowerShell, SQL, C#, Python, Json
  • The Power shell scripts will be a combination of scripts that need admin privilege's, most likely a service account, and scripts that can be run by users on artifacts that they have access to. 
  • How to handle secrets needs to be solved.
  • We will start with a PowerShell script that generate a list of all dataflows, using PBI rest APIs.   
  • Amy Pasko it is important to comment code.
  • Eric Johnstone it is good to have samples that users can reference.
  • Eric Johnstone - there are 3 service accounts with site admin access that do not require MFA.  These can be used to execute the power shell scripts for the inventory report.

Future Discussions

Eric Johnstone can help with VS power shell environment and using commandlets and rest apis to query Power BI objects. 

 Action Items




Related content

20220421 Power BI Developers - Tour of CAPS PBI, Site inventory
20220421 Power BI Developers - Tour of CAPS PBI, Site inventory
Read with this
20220512 Power BI Developers - Site Mgmt.; Rest APIs
20220512 Power BI Developers - Site Mgmt.; Rest APIs
More like this
20220623 Power BI Developers - Project Sharing
20220623 Power BI Developers - Project Sharing
More like this
20220707Power BI Developers - Demos and discussion
20220707Power BI Developers - Demos and discussion
More like this
20220519 Power BI Developers - Trouble shooting - Pct Total measures, data flow refreshes,
20220519 Power BI Developers - Trouble shooting - Pct Total measures, data flow refreshes,
More like this
20210805 - Power BI Developers - Measuring PBI Site Usage
20210805 - Power BI Developers - Measuring PBI Site Usage
More like this