~/talk

Power BI governance, disaster recovery and auditing

Talkat SQLBits 2023 · 2023-03-14..03-18· [devops-and-delivery]
links:none on file
slides:none on file

Recommends a three-tier Power BI estate: centralized datasets, departmental enhancements and personal overlays, using composite models (DirectQuery over datasets) so changes occur once not fifty times. Advocates workspace-per-security-group, mandatory Active Directory groups, and row-level security rather than many region-specific reports. Uses apps plus a three-stage deployment pipeline (Dev/Test/Prod — pipeline promotion needs Premium; updating the app is a separate manual step). Monitors with Power BI Sentinel for multi-year usage logs, table-level lineage, nightly backups and change tracking for DR and auditing.

AI-written summary · about

  1. 0:00Introduction and setup
  2. 1:43Why governance matters
  3. 3:52Power BI architecture planning
  4. 9:07Workspace planning and security
  5. 16:10Security best practices
  6. 18:57Monitoring and auditing
  7. 22:24Summary and Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.