tabular excel hide
When table is hidden in SSAS Tabular it is still visible in Excel's PivotTable "Show Fields" drop down. See:
This should be quite an easy fix I guess, so please remove this bug and don't let us wait for years!
It's very confusing for users to have hidden tables in the drop down, without any function and no corresponding field in the field list.
Well? Would love a status update here... Seems like a pretty clear request.
This is needed to reduce confusion to end-users.
Power BI appears to hide the table appropriately, but in Excel "Show Fields" it is incorrectly showing a hidden table.
This is also an issue for multidimensional - Hidden measure groups are still visible in the "Show Fields" drop down. Would be nice to have this issue corrected on multidimensional as well.
Annette Andreasen commented
In large models this can be very confusing for the end user; also as we very often places calculated measures in a display folder / actually also making calculations on physical measures and place them in display folders. by now all hidden tables will be shown for the end user.
Daniel Otykier commented
It looks like Excel uses the XMLA DISCOVER command for MDSCHEMA_MEASUREGROUPS to populate the "Show fields" dropdown. For a Tabular model, this command seems to always return all the tables in a model - regardless of whether a table is hidden or not, or whether it contain any measures or not.
Logically, a table should not be reported as a measure group if it does not contain any (visible) measures. But to prevent breaking changes, I would suggest a new property or perhaps an annotation on the table, which would prevent that table from being reported in the DISCOVER command (or corresponding DMV) for MDSCHEMA_MEASUREGROUPS.
noah kluge commented
Power BI desktop will support this. it would be great if supported with Excel accessing a SQL tabular model.