Forum Discussion
Hide Multiple Tabs in Bulk
It would be great if we could "Hide" multiple tables at one time. Currently I have to hide each table one at a time. My data comes in about 120 different tables. Then I use the append to merge into appropriate groups. But when building the report I have to search thru all the tables to find the appended tables and the few others I want to use. Either way it costs me a lot of time!
Hi HYEasterly,
Thank you for sharing your use case. I understand the challenge of working with large data models, especially when dealing with over 100 tables and needing to keep your report view clean by hiding unnecessary tables.
Currently, Power BI does not offer a direct "bulk hide" feature within the default interface.
Anyhow, there are effective workarounds you can implement:Using Model View in Power BI Desktop:
- Navigate to the Model View.
- Multi-select tables by holding the Ctrl or Shift key.
- After selection, right-click and choose Hide in Report View.
This method significantly reduces the time compared to hiding each table individually from the Fields pane.
Using Tabular Editor (Recommended for Large Models):
- Tabular Editor is an external tool supported by Power BI.
- It allows you to connect to your model, select multiple tables, and set their IsHidden property to True in one go.
- This solution is ideal for efficiently managing large datasets.
Download Tabular Editor from the official site and integrate it with your Power BI Desktop.
Happy to help! If this addressed your concern, marking it as "Accepted Solution" and giving us "kudos" would be valuable for others in the community.Thank you.
5 Replies
Go to the data model view. Select the tables you want to hide. Then right click one of them and select "hide in report view"
Hi HYEasterly,
Thank you for sharing your use case. I understand the challenge of working with large data models, especially when dealing with over 100 tables and needing to keep your report view clean by hiding unnecessary tables.
Currently, Power BI does not offer a direct "bulk hide" feature within the default interface.
Anyhow, there are effective workarounds you can implement:Using Model View in Power BI Desktop:
- Navigate to the Model View.
- Multi-select tables by holding the Ctrl or Shift key.
- After selection, right-click and choose Hide in Report View.
This method significantly reduces the time compared to hiding each table individually from the Fields pane.
Using Tabular Editor (Recommended for Large Models):
- Tabular Editor is an external tool supported by Power BI.
- It allows you to connect to your model, select multiple tables, and set their IsHidden property to True in one go.
- This solution is ideal for efficiently managing large datasets.
Download Tabular Editor from the official site and integrate it with your Power BI Desktop.
Happy to help! If this addressed your concern, marking it as "Accepted Solution" and giving us "kudos" would be valuable for others in the community.Thank you.
Hi HYEasterly,
We wanted to follow up to see if our suggestion was helpful. Please let us know how things are progressing and if you are still encountering any issues.
If the response resolved your problem, you may mark it as the solution and give it a thumbs up to assist others in the community as well.
Thank you.
HI HYEasterly,
Just a quick check-in!
Has your issue been resolved with the information we shared? We’d be delighted to help further if needed.If the solution worked, marking it as Accepted and adding a Kudos would be much appreciated, it helps others find valuable answers.
Thanks for your continued participation.
Thank you! This works much better! v-sgandrathi
