PQ refresh

[rjmdc]

hi
what does this mean and why does it happen
Information: Preview refresh was canceled. If you have disabled the downloading of data previews in the background, this is expected since only one preview will be allowed to refresh at a given time. This has no impact on your loaded data. To see the result of this query, please manually refresh the preview in the Power Query Editor.

do i want enable background refresh checked or unchecked?

 

[Matt Allington]

do i want enable background refresh checked or unchecked?

It depends. You should have a current copy of cached data showing when you edit your queries, otherwise what you are looking at in the screen may be wrong. It’s very convenient to let PQ do this for you automatically. But some refreshes can be slow, sometimes maybe 10 mins. In this case, you may want to turn it off and manually trigger the refreshes when you need to.

I don’t know why the previews were cancelled