duplicate names in excel power pivot

%3CLINGO-SUB%20id%3D%22lingo-sub-2072899%22%20slang%3D%22en-US%22%3Eduplicate%20names%20in%20excel%20power%20pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2072899%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Guys%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20one%20issue%2C%20why%20when%20i%20add%20tables%20to%20data%20model%2C%20i%20end%20up%20in%20power%20pivot%20showing%20same%20table%20name%20once%20as%20data%20model%20%26amp%3B%20once%20as%20table%2C%20as%20u%20can%20see%20in%20snapshot%20below%2C%20although%20when%20am%20creating%20pivot%20table%20i%20use%20insert%20%2Cthen%20use%20excels%20data%20model%2C%20how%20to%20eliminate%20this%20issue%3F%20any%20tweak%20%2Ftip%20for%20that%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22duplicate%20names.png%22%20style%3D%22width%3A%20242px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F247367i58BBEB4C590C12F8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22duplicate%20names.png%22%20alt%3D%22same%20names%20multiple%20times%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Esame%20names%20multiple%20times%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2072899%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2074034%22%20slang%3D%22en-US%22%3ERe%3A%20duplicate%20names%20in%20excel%20power%20pivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BI%20loaded%20them%20in%20power%20query%20to%20data%20model%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20now%20if%20i%20hide%20them%20i%20think%20all%20the%20data%20will%20be%20hidden%20isnt%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello Guys

 

I have one issue, why when i add tables to data model, i end up in power pivot showing same table name once as data model & once as table, as u can see in snapshot below, although when am creating pivot table i use insert ,then use excels data model, how to eliminate this issue? any tweak /tip for that?

same names multiple timessame names multiple times

3 Replies

@chahine The three at the bottom are the structured Excel tables in your workbook. The ones with the yellowish icon in it are tables that were loaded into the DM via PowerQuery.

If you have not already done so, you can add the Excel tables to the DM, and in Diagram View, select them and choose "Hide from Client Tools". Then they will not show up anymore.

Screenshot 2021-01-19 at 07.09.18.png

@Riny_van_Eekelen I loaded them in power query to data model

 

but now if i hide them i think all the data will be hidden isnt?

@chahine No worries! The tables are still in your sheet / DM, but you hide them to avoid clutter or to ensure that you can't accidentally use their fields in pivot tables. You're hiding the references to the tables, not deleting the tables.