Hiding Fields in a Power BI Report and Service

Leave a comment

Let’s look at how to hide a field in a Power BI Report.

First, let’s create a report and add some data. Open Power BI Desktop, and let’s click on Enter Data. We will create 2 columns, Customer Id and Customer Name.

Enter the data and click Load:

We now have the 2 fields in our report:

Let’s hide the Customer Id field. Right-click it and select hide:

The field now disappears from the view, but the data is still available on the report:

Let’s publish this up to the Power BI service. We can see the field remains hidden:

Now back in Power BI Desktop, let’s right-click the data to View Hidden fields:

We can see the Customer Id field we hid is now showing as italics and greyed out:

Clicking on it, we can use it in our report if we wanted to:

Let’s save the report and publish to the Power BI Service it with this setting.

We can see the report is updated, and the field remains hidden.

Also note we don’t have the option to hide fields for this report once in the service:

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

Leave a Reply

Your email address will not be published. Required fields are marked *