Duplicated transform Files in Power Query Editor

[Anonymous]

Hello,

My apologies in advance if this question has already been asked, if so I cannot find it.

My problem is the following. I have a small data model with 4 tables. Those four are picked from four different folders. The report works as expected, always getting the latest file available. 

However, in the power query editor there are already 55 queries automatically added. A huge list. While I understand that some of them are neccesary, according to the names of the groups I think there is some sort of redundant/useless loop working, but I cannot deleted them, and I'm afraid that the list will keep growing. 

Any clue why this is happening? I would like to clean the Power Query Editor if possible.

Many thanks!

[v-kelly-msft]

Hi @Anonymous ，

You can use advanced editor in query editor to modify your queries.Here is the related document,hope it would help.

  
Best Regards,
Kelly

[Anonymous]

Hi @v-kelly-msft 

Many thanks for your feedback. This is what I'm referring to. 57 queries and growing, I do not understand why.  Is this a normal behavior?