Share via

Remove tables from pivot table field list

Anonymous
2020-03-24T20:03:02+00:00

I have a workbook that uses tables, Power Query connections to those tables, a data model, and pivot tables/pivot charts for users to analyze the data model. 

The pivot table field list contains both the Data Model tables (with measures, only the columns I want users to see etc.) and the original data tables:

I only want users to be able to see the Data Model tables to avoid confusion. So in the picture above they would only see the first Employees table, not the second. How can I remove the original tables from the pivot table field list?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-03-24T23:43:18+00:00

    Hi phreid,

    I go through the post, I think you can hide tables so that it will not show in the list. Please see details in the article with video: Power Pivot reporting properties: Hiding tables, columns, and fields from Power Pivot and Power View.

    Hope these can help you.

    Regards,

    Clark

    0 comments
  2. Anonymous
    2020-03-25T02:58:51+00:00

    Hi phreid,

    I go through the post, I think you can hide tables so that it will not show in the list. Please see details in the article with video: Power Pivot reporting properties: Hiding tables, columns, and fields from Power Pivot and Power View.

    Hope these can help you.

    Regards,

    Clark

    Thanks for your suggestion. Unfortunately this isn't my issue, as you can see below the tables do not show in Power Pivot so I can't hide from client tools. 

    0 comments
  3. Anonymous
    2020-03-26T10:09:33+00:00

    Hi phreid,

    Thanks for your updates. i think suggestion below may help you:

    1. As you can see in screenshot, I want to hide the Table 1

     

    1. In Power Pivot, click Manage.

    1. In Data view, Find Table 1 in **tabs,**right click it and choose Hide from Client Tools

    ****

    1. Table 1 is hidden now:

     

    Hope these can help.

    Regards,

    Clark

    0 comments
  4. Anonymous
    2020-03-26T15:56:48+00:00

    Hi phreid,

    Thanks for your updates. i think suggestion below may help you:

    1. As you can see in screenshot, I want to hide the Table 1

     

    1. In Power Pivot, click Manage.

    1. In Data view, Find Table 1 in **tabs,**right click it and choose Hide from Client Tools

    ****

    1. Table 1 is hidden now:

     

    Hope these can help.

    Regards,

    Clark

    As I said, the tables do not show in Power Pivot, even with "Show Hidden" enabled: 

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2020-03-27T15:48:45+00:00

    Hi phreid,

    Thanks for the updates. Have you tried click Refresh and check the result?

    Regards,

    Clark

    0 comments