Query Refresh Versus Query preview ?

[Nicaustral]

Hi,

I have a query refresh that takes a very long time, whereas when I am in the query editor,
the preview is very quick.


Query Editor diagnostic tool :

(almost instant)
"close and apply" -> 30mn ...

What is thre difference between the 2 process so I can undertsand why it does take so much time in the normal refresh .
Or what steps can I do to solve the issue ? 

Thank you,

[v-yetao1-msft]

Hi @Nicaustral 

I found some similar information, maybe you can refer to

https://community.powerbi.com/t5/Desktop/Refresh-Preview-All-power-query-or/m-p/998908

https://www.reddit.com/r/PowerBI/comments/mc8x57/difference_between_refresh_preview_in_pq_and/

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Nicaustral , Check if this dicussion tread can help you

https://www.reddit.com/r/PowerBI/comments/mc8x57/difference_between_refresh_preview_in_pq_and/