Forum Discussion
Hide Multiple Tabs in Bulk
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,
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.
Thank you! This works much better! v-sgandrathi