Forum Discussion
Main Query refreshing twice after merge table
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!
Eliminate the merge steps.
3 Replies
- lbendlin
Super User
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.
- lbendlin
Eliminate the merge steps.