Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Fields hidden in the dataset are visible through PBI Services interface

My team creates and maintains datasets for report developers and business users within our finance team. A user of ours just noticed that the folders/fields hidden from reporting in PBI desktop and in Analyze in Excel are visible when creating a report online using PBI Services. 


To recreate the issue:

  1. Hide a field in the published dataset.
  2. Open a new PBI desktop report, make a live connection to the dataset, the field is hidden. It is visible in the model tab, shows as hidden and cannot be pulled into the report.
  3. Navigate to the dataset in PBI Services, select Create from Scratch. The same field is visible and available to be pulled into a report. 

Is this a new feature or bug? Has this been always been the case? 

Community Support
Community Support

Hi @AdrienneB ,


This is a new known issue (ICM:264013598) and the PG team is working hard to fix this issue. 
Sorry we don't have workaround at the moment, The ETA_for_Fix is10/5/2021.
If there are any updates, I will give you feedback here in a timely manner.


Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Regular Visitor

Having the same issue, Power BI service started displaying hidden fields. Is this related to recent updates?

Thanks for confirming that it is not just me and our setup. I am fairly sure that this is a new "feature". 

I'm also experiencing this. 


Very frustrating - as it was working as expected a few days ago.   Hidden tables & fields are now visible to the user within the PBI service when accessing the dataset.   


 There are some issue raised for it (please upvote)










Super User
Super User

Hi @AdrienneB 


When fields are hidden it means that it is just marked as to not show when in a particular dataset. It is always there.

That is why when using Excel or connecting to the dataset all hidden fields can be shown by unhiding them. This is by design.

The only way to not show them is to remove them from the dataset.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

@GilbertQ , the expectation I had and pretty sure in the past it was like that, that the hidden fields' names are visible in the model but they are not available for reporting. As of today, a hidden field can be used for reporting using the PBI Services report writer. Please test it out: hide a field in the dataset then start a new report in PBI Services using that dataset and you will see that the hidden field is not hidden at all. This seem to be a new thing, I am fairly sure that in the past hidden fields were hidden in desktop and services. 

Definitely a new issue.  I've been managing the same large dataset for 2 years now and just now are hidden fields showing to Users.  It looks terrible.


Imagine having a Dimension table with "SKU" and 10 Fact tables with the matching "SKU".  Now, when you search for the field "SKU", instead of just the Dimension table showing it, ALL 11 Tables pop up.  Terrible.

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors