Disable "see records" on a web dashboard

[nathanh]

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!

[v-haibl-msft]

@nathanh

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

Best Regards,

Herbert

[ankitpatira · Accepted solution]

@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.

[smerchant]

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'

[Anonymous]

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

[nathanh]

Thanks - hiding the columns solves the problem for me 🙂 

[Seth_C_Bauer]

@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"..