~/talk

Find your PII reports and make your data safer

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

Three methods to locate PII are described with concrete tradeoffs: Premium scan that adds 30% extra compute to every refresh and misses some fields; database-level classification via Synapse/Azure SQL that auto-mombs models to sensitivity labels; and a Gateway/cloud-connector pattern that maps connection IDs to enforce service-account access. Practical steps include using Microsoft Purview, DLP and Microsoft Defender, auditing re-share and downloads, and watch for scale issues (examples: 10,000 reports, 6,000 sources).

AI-written summary · about

  1. 0:00Introduction
  2. 3:00Locate PII in Power BI
  3. 9:33Track PII with Gateway connectors
  4. 15:54Information protection and DLP
  5. 23:05Sensitivity labels in Power BI and Fabric
  6. 27:42Parent labels and security risks
  7. 30:29PII scanning and labeling policies
  8. 34:10Microsoft Defender for data protection
  9. 41:17Block external users and personal workspaces
  10. 43:48Monitor reshare access and usage
  11. 49:12Audit settings 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.