Column fails to refresh in direct query mode

[balaganeshmohan]

I have 3 calculated columns in an imported table that gets data from live dataset in direct query mode.

DateIn = CALCULATE( MIN ( InOutOData[DateFrom] ), FILTER( InOutOData, InOutOData[SKUCode] = 'SKU Forecast'[SKU Code] && InOutOData[Status] = "INTRODUCTION"))

DateOut = CALCULATE( MIN ( InOutOData[DateFrom] ), FILTER( InOutOData, InOutOData[SKUCode] = 'SKU Forecast'[SKU Code] && InOutOData[Status] = "OUT"))

Test = 
    IF( 'SKU Forecast'[Week Start Date] > 'SKU Forecast'[DateIn] && 'SKU Forecast'[Week Start Date] <= 'SKU Forecast'[DateOut], "IN", "OUT")

This works in Desktop with values and visuals working correctly, but after web refresh of the live connected dataset, the report breaks down with the following error,

I couldn't understand what the problem here is, it is a simple calculation. Some things to note here, datein and dateout are of dtpye date with null values in them. Test is of type text. Any ideas what's going on here?

[v-tangjie-msft]

Hi @balaganeshmohan ,

This error may be caused if the column type of [Test] couldn't be understood by your web system. Check the type of this column.

It might be the date type or "out of bound" issue. Refer to this document to check the limitations of direct connection mode . 

Please check the version of your Power BI desktop, if it is not the latest verison, update it in web and publish your report again.

You can refer to the following posts that may be helpful to you:

Solved: The query referenced column ****** which depends o... - Microsoft Power BI Community

Solved: On calculated field, using the date hierarchy caus... - Microsoft Power BI Community

Solved: Date Hierarchy - couldn't load the data for this v... - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[balaganeshmohan]

Sorry None of that seems to be helping, I tried changing the datatype of the calculated columns to Text and still end up with the same problem!