Power Query - Warning, but no errors

[Danfountain]

Hi all,

I have just started to get knee deep into power query (done simple stuff before but now using M query).

So I have a sheet that everything seems to work fine. However sometimes in the query and connections view - when i refresh it comes back with a warning exclamation but no errors. Usually after a while the exclamation mark disappears. All the data seems fine and if i run through the step by step there are also no errors.

I found another report on a forum experiencing the same thing, but no answer. Any ideas why this happens?

Dan

 

[Danfountain]

I have found something else. If you hover over the to get the preview and then wait for the sources to be calculated - it goes away. Odd.