20190919 - Power BI Developers
- Ann Crawford (Unlicensed)
Meeting Details
Date/Time/Location
- Location: https://ucsb.zoom.us/j/223753798
- 9:00-10:00
Attendees
Meeting Goals and Expected Preparation
Goals
- Power BI Security model must answer who has access to what and who has accessed what when?
Expected Preparation
Read Power BI documentation on security; /wiki/spaces/PB/pages/773718243
Agenda
| Time | Topic | Owner |
|---|---|---|
| 5 m | Review use cases and questions in the comments to determine topics for the meeting. | All |
| 20 m | Power BI Audit Demonstration of scripts to capture Power BI Auditing | Mark Norstedt |
| 10 min | Power BI data set documentation and Security Settings for application sharing. | Ann Crawford (Unlicensed) |
| 10 min | User Training material and documentation | TBD |
| 10 m | Questions / Next Steps | All |
Discussion
Michael Nesbit (Unlicensed) reviewed training and data set documentation. All domain experts should think about how to document and train users to understnad their data. Bruce Miller mentioned that ETS is exploring data catalog tools, informatica, Erwin.
Mark Norstedt reviewed progress POC on the data auditing and parsing the datamashup file to get the data set details. It is not necessary to get everything from the file. Anything can help. He is focusing on the Power BI tables and columns. Needs to explore how the file changes when it is created using a dataflow vs a direct query to the database. Eric Johnstone mentioned that he can work with Mark Norstedt to integrate DLP policies into the data set.
Action Items
- Ann Crawford (Unlicensed) create a data set that is built from data flows.
- Eric Johnstone work with Mark Norstedt on a POC of appying DLP policies to the power bi data sets.
Action Items from 9/12
- Eric Johnstone work with Joseph Chanson to brand the PBI Login from Microsoft brand to UCSB brand - this has changed to allow Eric to get direct access and work with Allen Biehle.
- Ann Crawford (Unlicensed) shared google sheet with Joshua Munsch (Unlicensed) and Mark Norstedt - done. We reviewed the JSON this is still a work in progress.
- Mark Norstedt and Joshua Munsch (Unlicensed) create a separate data sets for the PBI reports with naming convention dataset_<somename> and document in the data sheet