Forum Discussion
Cleaning the pivot table fields list in the data model
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
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?
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.