cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nathanh Frequent Visitor
Frequent Visitor

Disable "see records" on a web dashboard

I've been using Power BI web dashboards for a while, but just realised it is possible to view the records behind a visual, not just the aggregated data. I would like to turn this off so that I can hide sensitive data. Is there any way to do this? 

 

As an example, this was published on the Power BI blog and exposes names and locations of individuals. This is often not desirable or necessary. 

 

Thanks for your help in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
ankitpatira Super Contributor
Super Contributor

Re: Disable "see records" on a web dashboard

@nathanh there is no out of the box way but before publishing from power bi desktop if you right click columns and hide them then they won't appear under See Records. Also if you change mechanism to directquery rather than import you won't get See records option but those are the only two ways I know so far and first one is better but that also means you won't be able to use that column in any visuals.

6 REPLIES 6
Super User
Super User

Re: Disable "see records" on a web dashboard

@nathanh I know there are tenant settings to disable "export", but I'm not aware of any way to disable "see records" or "see data"..

Near SE WI? Join our PUG Milwaukee Brew City PUG
ankitpatira Super Contributor
Super Contributor

Re: Disable "see records" on a web dashboard

@nathanh there is no out of the box way but before publishing from power bi desktop if you right click columns and hide them then they won't appear under See Records. Also if you change mechanism to directquery rather than import you won't get See records option but those are the only two ways I know so far and first one is better but that also means you won't be able to use that column in any visuals.

v-haibl-msft Super Contributor
Super Contributor

Re: Disable "see records" on a web dashboard

@nathanh

 

You can try with the ways provided by ankitpatira and please vote this idea here.

 

Best Regards,

Herbert

nathanh Frequent Visitor
Frequent Visitor

Re: Disable "see records" on a web dashboard

Thanks - hiding the columns solves the problem for me Smiley Happy 

smerchant Regular Visitor
Regular Visitor

Re: Disable "see records" on a web dashboard

Is this solution still working?  I have hidden all the columns from my report.  I don't see them in the fields list now.  I have published this report and I still see 'See Records'

gbru Frequent Visitor
Frequent Visitor

Re: Disable "see records" on a web dashboard

You can try to do the following:

In every visual where you e.g. count an ID or sum up something these might show the "See records" label

 

Use a measure instead of the built in counting or summing functions (in the fields -> values part of your visual):

e.g. set a measure to count your IDs or sum up your values and then put this measure as the value in your visual

 

Now the "see records" in Power BI service should translate into "show data" and your users can only see the aggregations but not the actual IDs or sales values etc.

 

Let me know if it worked

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 46 members 956 guests
Please welcome our newest community members: