Removing tables from pivot table after creating relationships in Power Pivot

[INN]

Hi
I have 2 tables, SalesTb and NameTable. I created a relationship using Power Pivot. Form PowerPivot, I clicked on Pivot Table. Now I see pivot tables fields list but I see tables there I do not want (old), how can I delete them from Fields list? I checked Queries & Connections pane and I only see my tables. So from where these other tables came from and how to delete them? Thank you very much.

 

[jdellasala]

Look immediately below PivotTable Fields in your (oversized!) screenshot, and you'll see All which is the list of all the tables available to your Pivot Table, and to the left of it Active. Right Click on tables you want to use and select Show in Active Tab.

Once you've done that to all the tables you want to see, click on Active and only the tables you need will be listed.

Similarly you can do this in the Diagram view of the Data Model where you can hide fields:

In the pic above Total Sales is a measure that calculates the SUM of Sales Value, so not only is Sales Value not needed, but it's slower. By selecting Hide from Client Tools the field won't be listed preventing its use in a Pivot Table. This is especially true where many tables have a Date field, but only a field from the Calendar Table should be used and date fields from other tables should be hidden.

Those are general rules, and I'm sure there are instances where they don't hold. Anyway, what you do NOT want to do is delete tables or relationships!

 

[INN]

Thank you so much and I will not post oversized screenshot anymore