Calculated tables with direct query tables

Hi,,

My report contains 2 datasets "direct query" and multiple calculated tables. When I publich this notification pops up 

And when I try to refresh the published error I get this error

I tried to fix this from the schedule refresh for the dataset on the service but i dont think it is realted 

Is there a workaround for this? some datasets are large and we need to build on for another reports, it can't be the only solution is to build the dataset again and include these calculated table into it.

Please advice 🙂