...
If a semantic model is connected using SQL, then entities hidden in the semantic model are considered as visible as the checkbox is not cleared in the SQL metadata, and SQL protocol does not support the hidden attribute.
If the semantic modelĀ is connected using a TDS file, then the entities hidden in the cube semantic model will not be shown in Tableau. Tableau provides an option to reveal those entities on the visualization screen.
To exclude any entity from a TDS file, you should clear the checkbox for it from the SQL metadata.
When exporting semantic model metadata, if the entity is hidden in the cube semantic model design, then all the levels and attributes are a part of the TDS file, with the hidden attribute wherever applicable. Tableau keeps these entities hidden until you unhide them from the Tableau screen. To exclude the entity from a TDS file, clear the checkbox for the entity from SQL metadata.