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
6 Replies
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.
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.
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?
