Issue with Refreshing in Power BI Service

[Anonymous]

Good afternoon Team,

I am receiving this error for reports titled AM Report Treasury Uninvested Cash and PM  Report Treasury Uninvested Cash. These reports run in the morning and afternoon to reference changes in each other's dataset. This week they started producing this error that I am trying to figure out how to resolve.

Thanks in advance!

[3CloudThomas]

Calculated tables and calculated columns do not work with DirectQuery models.

[lbendlin]

Not entirely correct.  Calculated Columns can be used if they reference the same row. Called "Direct Query with local model"