Forum Discussion

john_ach's avatar
john_ach
Frequent Visitor
5 years ago
Solved

Incorrect Errors in Appearing in Dataflows

Hi,   I have a set of dataflows which have been working and refreshing hourly for the past week. From 8pm BST yesterday (Sunday 13th June) all subsequent hourly refreshes have failed. No changes ha...
Dataflow
Need Help
  • john_ach's avatar
    john_ach
    5 years ago

    I have discovered a workaround that seems to have removed the error, which can hopefully help some people in the short term. I don't think this should be necessary though - this seems to be a more fundamental issue in Power BI service?

     

    The workaround for me was to cast the (date type) field to a date type in the filter logic, for example:


    From 

    [Record Date] > DateTime.Date(DateTime.LocalNow())


    to

    DateTime.Date([Record Date]) > DateTime.Date(DateTime.LocalNow())


    Just to reiterate that [Record Date] field is already of Date type..

mikesmith_bp's avatar
mikesmith_bp
Frequent Visitor
5 years ago

I am getting the same error on a dataflow that has been running for a long time.  It began to fail early on Jun-14 and and failed everytime since.  The error message is 

We cannot apply operator < to types Date and DateTime. Operator = < Left = 4/1/2021 12:00:00 AM Right = 10/31/2020 12:00:00 AM

john_ach's avatar
john_ach
Frequent Visitor
5 years ago

I have discovered a workaround that seems to have removed the error, which can hopefully help some people in the short term. I don't think this should be necessary though - this seems to be a more fundamental issue in Power BI service?

 

The workaround for me was to cast the (date type) field to a date type in the filter logic, for example:


From 

[Record Date] > DateTime.Date(DateTime.LocalNow())


to

DateTime.Date([Record Date]) > DateTime.Date(DateTime.LocalNow())


Just to reiterate that [Record Date] field is already of Date type..