Hide tables when using personalize feature

Based on my understanding, the Personalize visuals feature exposes all fields from the dataset by default. Without additional configuration, users will see both the Query1 and Query2 tables even if they access only one page.

We can achieve the desired behaviour without splitting the report by configuring Perspectives in the model and assigning them to each report page. When a perspective is assigned to a page, Personalize visuals displays only the fields included in that perspective for that page.

1. In Power BI Desktop with TMDL view enabled, create a perspective for Query1 and another for Query2.
2. On each report page, open the Format pane and assign the appropriate perspective.
3. Publish the report and verify. Users on Page1 will see only Query1 fields when personalizing, and users on Page2 will see only Query2 fields.
4. If you need to hide objects completely rather than only simplify Personalize visuals, configure Object-Level Security (OLS) via TMDL. This approach allows you to maintain a single report and reduces maintenance overhead. If TMDL is blocked in your tenant, please consult your administrator.
   
   

   Please refer to the links below for further information:
   Personalize visuals in a report - Power BI | Microsoft Learn
   Let users personalize visuals in a report - Power BI | Microsoft Learn
   Tabular Model Definition Language (TMDL) | Microsoft Learn
   Use Tabular Model Definition Language (TMDL) view in Power BI Desktop - Power BI | Microsoft Learn
   Object-Level Security (OLS) with Power BI - Microsoft Fabric | Microsoft Learn
   
   

   We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

   Thank you.