Jan 18 2021 07:39 PM
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?
Jan 18 2021 10:14 PM
@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.
Jan 19 2021 04:13 AM
@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?
Jan 19 2021 04:34 AM
@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.