Here we can see, “You Can Disable See Records in Power Bi in 2 Easy Steps”
Power BI is an excellent tool for organizing and visualizing data. There are, nevertheless, circumstances where certain facts must be kept a secret. Unfortunately, there is no easy way to disable “See Records” in Power BI.
For a lot of people, this is a serious issue. On the official forum, one member posted the following:
There should be an option to disable “see records” for the graphics that support it. It is a huge issue when it comes to security. I know you can hide certain columns but in reports that should only be high level data, the see records item is really an issue.
As a result, you can conceal specific columns but not the choice to see records. Although there are a few workarounds, as we previously stated, there is no direct way to accomplish that.
Steps to disable see records in Power BI
1. Hide columns
-
- From Power BI Desktop, right-click columns to conceal them before publishing.
- Verify that they are still listed under See Records.
2. Change mechanism to DirectQuery
Change the technique to DirectQuery rather than Import to prevent records from appearing in Power BI.
Considering that you won’t be able to use the column in any visuals, the first option is a superior solution.
See Records feature is available, but only in some cases
The See Records option is typically used to display all the details for a single record or data point that has been chosen. However, there are certain restrictions on the feature.
It only appears in the funnel, pie chart, map, bar chart, column chart, treemap, filled map, and donut chart visualization types.
Additionally, you cannot utilize See Records when Power BI is linked to a live multidimensional (MD) model or when your visual employs a calculated measure.
Therefore, if the ribbon’s See Records button is disabled, the chosen dashboard doesn’t support this feature.
Conclusion
I hope you found this guide useful. If you’ve got any questions or comments, don’t hesitate to use the shape below.
User Questions
1. How can I stop Power BI from showing records?
-
- Conceal columns. Columns can be hidden by right-clicking them and then publishing from Power BI Desktop. Make sure they are still listed under See Records.
- DirectQuery is the new mechanism. Change the technique to DirectQuery rather than Import to prevent records from appearing in Power BI.
2. How does Power BI’s visual hiding and showing work?
Select the [Make Transparent] measure, click on Conditional formatting, and then choose Format by as “field value” and “Based on the field.” Importantly, the visuals must appear in the following order from front to back: a card. The image to reveal or conceal.
3. In Power BI, is data concealable?
Additionally, importing Excel spreadsheets into Power BI Desktop is simple. A table, column, or field that is hidden is only hidden from view; it is not deleted. The data model still includes the table, column, or field. You can choose to show hidden data in Power Pivot or not.
4. Remove a line of data? : r/PowerBI – Reddit
5. Any way to turn off the new UI? : r/PowerBI – Reddit
