Table in query preview is different from table in visualisation

[Anonymous]

Hi all,

I encountered this weird scenario where the preview table in query showed there were null cell, but the visualisation table showed everything was good, no null cell exist. I cannot perform query because of the null cell. I have refreshed the queries step by step but still is not working. Can anyone help, please.

[v-danhe-msft]

Hi @Anonymous,

That is quite weird. How about refreshing? If refreshing can't solve it, could you please provide the file (pbix)? It's too hard to reproduce your problem.

Regards,

Daniel He