Home

Cleaning the pivot table fields list in the data model

%3CLINGO-SUB%20id%3D%22lingo-sub-773114%22%20slang%3D%22en-US%22%3ECleaning%20the%20pivot%20table%20fields%20list%20in%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773114%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20per%20the%20attached%20screenshot%2C%20I%20would%20appreciate%20your%20support%20to%20advise%20how%20to%20delete%20the%20yellow-colored%20duplicated%20Queries%20in%20excel%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-773114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Model%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773156%22%20slang%3D%22en-US%22%3ERe%3A%20Cleaning%20the%20pivot%20table%20fields%20list%20in%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381954%22%20target%3D%22_blank%22%3E%40Ali_Saad_Rashed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20how%20did%20you%20add%20these%20tables%20to%20data%20model.%20If%20by%20Power%20Query%20you%20may%20delete%20these%20extra%20queries.%20Or%20you%20may%20open%20Power%20Pivot%20(shall%20be%20available%20for%202013%20depends%20on%20Excel%20version)%20and%20hide%20or%20delete%20these%20tables.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773170%22%20slang%3D%22en-US%22%3ERe%3A%20Cleaning%20the%20pivot%20table%20fields%20list%20in%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773170%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20your%20reply%3C%2FP%3E%3CP%3EI%20have%20created%20them%20through%20Power%20Query%3C%2FP%3E%3CP%3Ehow%20to%20delete%20the%20extra%20queries%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20per%20the%20attached%20file%2C%20I%20can%20not%20find%20them%20in%20the%20current%20queries%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773218%22%20slang%3D%22en-US%22%3ERe%3A%20Cleaning%20the%20pivot%20table%20fields%20list%20in%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773218%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381954%22%20target%3D%22_blank%22%3E%40Ali_Saad_Rashed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20you%20created%20Pivot%20Table%20based%20on%20source%20table%2C%20and%20query%20same%20source%20table%2C%20in%20both%20cases%20with%20adding%20data%20to%20data%20model.%20When%20it'll%20be%20two%20tables%20in%20data%20model%20with%20similar%20names%2C%20but%20they%20could%20be%20different%20since%20with%20Power%20Query%20you%20could%20make%20some%20transformation%20of%20the%20data.%20Is%20that%20like%20so%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773222%22%20slang%3D%22en-US%22%3ERe%3A%20Cleaning%20the%20pivot%20table%20fields%20list%20in%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773222%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20agree%2C%20how%20to%20fix%20it%20now%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773246%22%20slang%3D%22en-US%22%3ERe%3A%20Cleaning%20the%20pivot%20table%20fields%20list%20in%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773246%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381954%22%20target%3D%22_blank%22%3E%40Ali_Saad_Rashed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20you%20need%20to%20decide%20which%20of%20the%20tables%20you%20need%20in%20data%20model%2C%20since%20even%20with%20similar%20names%20content%20could%20be%20different.%20If%20remove%20one%20created%20by%20Power%20Query%20-%20right%20click%20on%20the%20query%20in%20right%20pane%2C%20Load%20To%2C%20and%20unselect%20Add%20data%20to%20data%20model.%20It%20will%20refresh%20the%20query.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20one%20created%20by%20PivotTable%20on%20source%20table%2C%20when%20perhaps%20to%20rebuild%20this%20PivotTable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773272%22%20slang%3D%22en-US%22%3ERe%3A%20Cleaning%20the%20pivot%20table%20fields%20list%20in%20the%20data%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773272%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eregretfully%2C%20I%20tried%20to%20rebuild%20the%20pivot%20table%20and%20no%20use...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eappreciate%20you%20patience%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ali_Saad_Rashed
New Contributor

Hi Guys 

as per the attached screenshot, I would appreciate your support to advise how to delete the yellow-colored duplicated Queries in excel 2013

 

 

Thank you

6 Replies

@Ali_Saad_Rashed 

 

It depends on how did you add these tables to data model. If by Power Query you may delete these extra queries. Or you may open Power Pivot (shall be available for 2013 depends on Excel version) and hide or delete these tables.

@Sergei Baklan 

thanks for your reply

I have created them through Power Query

how to delete the extra queries?

 

as per the attached file, I can not find them in the current queries list.

@Ali_Saad_Rashed 

As variant you created Pivot Table based on source table, and query same source table, in both cases with adding data to data model. When it'll be two tables in data model with similar names, but they could be different since with Power Query you could make some transformation of the data. Is that like so?

@Sergei Baklan 

 

I agree, how to fix it now?

@Ali_Saad_Rashed 

When you need to decide which of the tables you need in data model, since even with similar names content could be different. If remove one created by Power Query - right click on the query in right pane, Load To, and unselect Add data to data model. It will refresh the query.

 

If one created by PivotTable on source table, when perhaps to rebuild this PivotTable.

@Sergei Baklan 

 

regretfully, I tried to rebuild the pivot table and no use...

 

appreciate you patience 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies