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:
Is this a new feature or bug? Has this been always been the case?
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.
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)
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.
@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.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!
Watch Session 22 Ted's Dev Camp along with past sessions!
Click here to read more about the May 2022 updates!