Main Query refreshing twice after merge table

[rfinguerweg]

Hi there,

I have a main query from Oracle Database, and I merge with other tables to obtain other info columns that I need.

But after creating merge steps inside query, when I refresh data, my main query runs twice, and I am not using reference of this query, just using merge.

I have already searched about this but I couldn't find anything.

Thanks for your help guys!

[lbendlin]

How do you know it is running twice? 🙂

https://blog.crossjoin.co.uk/2020/07/05/why-is-power-bi-running-my-sql-query-twice/

(says SQL but applies to other sources too)

Say no to merges!  Let the data model do the work.

[rfinguerweg]

I can see the query loading all the rows 2 times, from the beginning.

I have seen your post, but it will not work for me, since my merged table is inside power query only (inserted data manually)

[lbendlin · Accepted solution]

Eliminate the merge steps.