~/talk

Sensitivity labels - what do they look like

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

Sensitivity labels act as metadata not automatic access control: they require Office 365 E5 to create and Power BI Pro/Premium PPU to apply, and service views show labels while enforcement is limited (exports to Excel can be blocked, Power BI desktop often does not prevent viewing). One label applies per artifact and reports inherit the most restrictive label when mashing sources, Azure SQL supports column-level classification (or MIP at DB level), Purview and Fabric scan and report uptake, and some tools (report builder, workbooks, B2B) have notable gaps.

AI-written summary · about

  1. 0:00Introduction
  2. 5:43Setup in M365 admin center
  3. 10:37Labels in Excel and Word
  4. 13:27Labels in Power BI Desktop
  5. 16:36Enable in Power BI service
  6. 20:10View labels in Power BI
  7. 22:58Labels in dataflows and dashboards
  8. 26:01Export to Excel and security
  9. 27:27Inheriting labels in reports
  10. 31:41Labels in Fabric and lakehouses
  11. 33:24Azure SQL protection options
  12. 36:57Scanning labels in Purview
  13. 40:11Gotchas and limitations
  14. 43:20Recap and Q&A session
~/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.