Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |