Hide tables resets to Unhidden with data refresh

[ThomasDay]

Hello all,

I am hiding tables to allow for report visuals to retain their "Export" data capabilities while restricting Analyze in Excel (it will only analyze unhidden tables).

Every time I refresh data in a .pbix file, any Hidden tables become Unhidden.  This must be a bug, but anyone know a workaround?

Tom

[v-yuta-msft]

Hi ThomasDay,

"Every time I refresh data in a .pbix file, any Hidden tables become Unhidden."

<--- Could you share some screenshot and clarify more details about what you have done?

Regards,

Jimmy Tao

[ThomasDay]

@v-yuta-msft  Hello Jimmy Tao,

Sure.  I have hidden every table in a model using the elipsis and Hide Table in Report View.

When I then refresh the model like so:

The end result is the following where you can see most tables are no longer hidden.  Tables sourced from SQL or as an xlxs file seem to remain hidden as is the formulas file since there is no source file for it.  

Let me know what you think and thanks,

Tom

[ThomasDay · Accepted solution]

@v-yuta-msft  The answer to keeping tables hidden in report view when refreshing a model in desktop is to do the refresh from the Data table view.  When you do that...all hidden tables remain hidden in report view and "analyze in excel" does not see them either.  (The purpose is to work around the issue where turning off "analyze in excel" can only be done if you also turn off "export" data from visuals as well.)

Tom