20220505 Power BI Developers - Site Mgmt.; Rest APIs
Meeting Details
Date/Time/Location
- Location: https://ucsb.zoom.us/j/223753798
- 9:00-10:00
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
- 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 | Group Discussion |
5 | Site Management
| 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:
| 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
- 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
- Ann Crawford (Unlicensed) - update the git repo structure
- Ann Crawford (Unlicensed) - give pbi developers access to the git repo
- Amy Pasko or Mike Smith bring an example of a power shell script comments for a template for the meeting.