Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Sampathkumar_v
Helper II
Helper II

How to mask the sensitive data in power bi desktop?

‎12-10-2024 10:20 PM

Hi Folks,

 

Can any one help us to maksing the sensitive data in power bi desktop in table view (my requirement is even developer shouldn't see the sensitive data) However, while creating any graph's in desktop verion it should display with real(sensitive) data will it be possible in power bi? please advise.

Labels:
Message 1 of 4
520 Views
0
1 ACCEPTED SOLUTION
danextian
Super User
Super User

‎12-10-2024 10:48 PM

If a developer has copy of the pbix, they will be able to see what's in the table view unmasked if data has been imported.  But whether DQ or import  I suggest you let them connect to tables with the same structure as the sensitive ones but containg dummy data instead and then re-route to the correct data once ready for publishing or testing.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Message 4 of 4
482 Views
3 REPLIES 3
danextian
Super User
Super User

‎12-10-2024 10:48 PM

If a developer has copy of the pbix, they will be able to see what's in the table view unmasked if data has been imported.  But whether DQ or import  I suggest you let them connect to tables with the same structure as the sensitive ones but containg dummy data instead and then re-route to the correct data once ready for publishing or testing.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 4 of 4
483 Views
Tahreem24
Super User
Super User

‎12-10-2024 10:43 PM

@Sampathkumar_v  Table View is only for preview purpose. You cannot make any modifications in the Table View. 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Message 3 of 4
494 Views
0
Brunner_BI
Super User
Super User

‎12-10-2024 10:42 PM

In Power BI Desktop I do not think this is possible. You could use sensitivity labels but those will protect the whole file as far as I know.

In the Power BI Service obviously you can use row-level security.

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog
Message 2 of 4
495 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All