How to find personal data in reports?

[talantir]

Hi,

is there a way to query if there is personal data in reports?

Personal data such as name + mobile number or bank account number or social number,

if there is a function to query all data at once, please let me know.

Also, I am curious if there is a way in PowerBI Report Server as well as PowerBI Service.

Regards,

[tayloramy · Accepted solution]

Hi @talantir, 

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.

[v-hjannapu]

Hi @talantir,

I would also take a moment to thank @grazitti_sapna, @tayloramy , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
community Support team.

[v-hjannapu]

Hi @talantir,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.

[grazitti_sapna · Accepted solution]

Hi @talantir ,

• 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-overv... 
• 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... 
• 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!

[tayloramy · Accepted solution]

Hi @talantir, 

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.