~/talk

Prepare for Fabric with Power BI Governance, Auditing and DR

Talkat SQLBits 2024 · 2024-03-19..03-23· [data-engineering, devops-and-delivery]
links:none on file
slides:none on file

Argues that governance must be planned, monitored and fixed with concrete controls rather than vague policies, showing a practical three-layer architecture (central, team, personal), workspace/dev-test-prod patterns, Git/deployment pipelines, and Fabric-specific complications like warehouses, lakehouses and preview mirroring. Demonstrates native features (promote/certify flags, sensitivity labels, RLS) plus external tools: Power BI Sentinel (automates audit/log extraction to a database, long-term retention, permission views, change tracking and backups with rollbacks), Purview, Tabular Editor and PBI Tools. One Security is not GA yet, so plan accordingly.

AI-written summary · about

  1. 0:00Introduction
  2. 1:12Governance in Power BI
  3. 3:20Power BI governance stages
  4. 4:42Avoid workspace sprawl
  5. 5:03Three-layer architecture
  6. 9:15Planning workspaces
  7. 10:41Dev/test/prod strategies
  8. 13:53Fabric governance challenges
  9. 17:44Git in Fabric and Power BI
  10. 19:11Fabric workspace structure
  11. 20:17Security with AD groups
  12. 22:47Fabric security overview
  13. 25:56Row-level security
  14. 29:50Sensitivity labels and DLP
  15. 32:18Promoted vs certified datasets
  16. 35:31Monitoring Power BI/Fabric
  17. 37:17Data lineage with Purview
  18. 43:18Fixing Power BI issues
  19. 45:22Tools for monitoring
  20. 45:44Key takeaways
~/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.