Data refresh after going to 'transform data'

[River]

Hi Friend,

It's weird that every time I go to 'Transform data', it starts refresh one of the tables. 

This table has a merge query, but so like other tables which are not refeshing. 

This is annoying and time consuming. I can't think of any reason for it doing this.

Any idea?

Many thanks.

[Anonymous]

@River 
This 'transform data' tab should not refresh data, it just opens query editor in power bi. The speed of loading phase is depended on the data size and complexity of existing steps in Power Query.

I am not sure what do you mean by "refresh after transform data", Do the data in query editor always updates/changes to newest data from datasources?

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.