/
20220505 Power BI Developers - Site Mgmt.; Rest APIs
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.
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