#GETTING DATA, DAX issue

[shophoney]

Hi, all of a sudden 4 of my tables wont update. They say "#GETTING DATA". Only if i go into dax and manually refresh will they update. Or if I select the QRY inside excel and refresh the workbook connection.

I've tried removing and readding it back to DAX. But still have the same issue?

Thanks