How to find personal data in reports?

Hi Anonymous, 

I don't believe there is a way to do this in Report Server. 

In the Power BI Service/Fabric, this is possible if the data is tagged with sensitivity labels I think. If the data is tagged, you should be able to use the scanner API to identify it. 

https://learn.microsoft.com/en-us/fabric/governance/metadata-scanning-overview

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Hi Anonymous ,

• Below mentioned article will help to classify and enable tagging sensitive data within Power BI reports.
  Link 1 :https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-security-sensitivity-label-overview 
• Sensitivity labels are part of Microsoft Information Protection (MIP). They let organizations classify and protect reports, and dashboards that \have sensitive or personal data — such as patient information
  or PII (Personally Identifiable Information).
• You can apply labels like “Confidential”, “Sensitive”, or “Highly Confidential – Personal Data” directly inside Power BI (Desktop or Service).
• This helps  control how the data is shared, exported, or downloaded — for example, preventing users from exporting to Excel or copying visuals if the report is labeled confidential.
• The labels travel with the data when it’s exported to Excel or PDF, ensuring consistent protection across Microsoft 365.
  Link 2:  https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-security-enable-data-sensitivity-labels 
• Admins must enable sensitivity labels in the Microsoft Fabric / Power BI Admin Portal before users can use them.
• You can sync existing labels from Microsoft Purview or Microsoft 365 Compliance Center so that the same classification scheme applies across Power BI, Outlook, Teams, SharePoint, etc.
• Once enabled, users can see a “Sensitivity” dropdown in Power BI Desktop and Service to apply the appropriate label.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!