cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Dashboard data obfuscation

While it's useful to share reports in healthcare a common issue that comes up is the content of the reports. If there is any Personal Health Information in a report (or in the details within the report) it is important to be able to obscure that information. Some companies who have built their own reporting solutions take care of this on their end. I was wondering if there was anything within PowerBI that would allow a report write to do this type of obfuscation so dashboards could be created with the possibility of violating HIPAA removed because any PHI would not be viewable in case someone shared the dashboard link with someone they shouldn't have. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Dashboard data obfuscation

Hi @ecarlstrom,

 

I think this should be done in the Power Query at the first place in Power BI. Remove columns, replace values or filter out records etc. You also can create an idea here: https://ideas.powerbi.com. Maybe we can have it in the future.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
New Member

Is it possible to "blur" or obfuscate certain data in PowerBI dashboards?

While it's useful to share reports in healthcare a common issue that comes up is the content of the reports. If there is any Personal Health Information in a report (or in the details within the report) it is important to be able to obscure that information. Some companies who have built their own reporting solutions take care of this on their end. I was wondering if there was anything within PowerBI that would allow a report write to do this type of obfuscation so dashboards could be created with the possibility of violating HIPAA removed because any PHI would not be viewable in case someone shared the dashboard link with someone they shouldn't have. 

Highlighted

Re: Dashboard data obfuscation

you can use Row Level Security however this provides access to data or not. I generally advise that you should assume that anyone that can see a report can also see the underlying data. The exception I guess is if you give read only access and also disable Analyse in Excel. You would want to test it fully of course. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
Microsoft
Microsoft

Re: Dashboard data obfuscation

Hi @ecarlstrom,

 

I think this should be done in the Power Query at the first place in Power BI. Remove columns, replace values or filter out records etc. You also can create an idea here: https://ideas.powerbi.com. Maybe we can have it in the future.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Dashboard data obfuscation


@MattAllington wrote:

you can use Row Level Security however this provides access to data or not. I generally advise that you should assume that anyone that can see a report can also see the underlying data. The exception I guess is if you give read only access and also disable Analyse in Excel. You would want to test it fully of course. 


Unfortunately I don't think that would work. Being able to see the results of metrics etc would be the reason for the dashboard, but any underlying patient specific data (name, date of birth, etc) would need to be obfuscated. The other option mentioned by Dale sounds closer, but I'm definitely going to post something in the ideas. 

 

Erik

 

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors