Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

tabular excel hide

60 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Michal Poziemski shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

7 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Power BI desktop will support this. it would be great if supported with Excel accessing a SQL tabular model.

Feedback and Knowledge Base