20211118Power BI Developers - Precision refreshes, Usage report

Meeting Details

Date/Time/Location


Attendees


Meeting Goals and Expected Preparation

Goals

  • Push the use cases and processes for Power BI

Helpful Preparation

  1. Review your content in PBI usage  Usage Report 

Agenda


TimeTopicOwner
5Welcome - questionsGroup Discussion 
15

Metrics

Power BI Adoption - Usage Report 

  • Enhancement discussion 
  • usage category review for dev, admin, user

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

Alyssa Keehan (Unlicensed)
20 

Using code to mange data refreshes 

Rather than rely on the PBI gui to set refresh schedules that must be on the half an hour, we can drive refresh with power shell code to shorten the window and avoid traffic jams on busy times. 

  • Mark Norstedt will show his code that used to work and engage the group to solve any issues and instruct on how we can take advantage 


Mark Norstedt
10

Report Questions/Example

Obsolete visuals example - what to do?

If anyone has anything we can discuss




Group

Discussion


Alyssa Keehan (Unlicensed) - showed the usage report and the fixes she is working on.

Diana Antova - requested a high level usage page: report views over time, Total number of departments, users per department, all over time. Also remove developers activity from the page.  Need to find a way to define developers because some users like Tedi are developers and users.

Mark Norstedt - demoed the power shell refresh located at https://github.com/ucsb/ucsb-sa-powerbi/blob/master/PowerShell/PowerBIUcsb/Scripts/Invoke-PBI_DataRefresh.ps1


 Action Items