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 have been made to the dataflows, and I don't think any changes have been made to the originating database. The error given is 'we cannot apply operator to types date and datetime', though it is noted against different entities in different dataflows depending on the specific refresh - I assume this is just due to sequencing/order of execution varying.I have checked the specific steps noted in the errors, and they are all Date type compared with Date type. This code also worked correctly over the past ~7 days without giving the error. The error appears to be incorrect. Has anyone experienced anything similar, or have any suggestions as to the cause and fix? Thanks for your help

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())toDateTime.Date([Record Date]) > DateTime.Date(DateTime.LocalNow())Just to reiterate that [Record Date] field is already of Date type..

Incorrect Errors in Appearing in Dataflows | Microsoft Fabric Community

Forum Discussion

Related content

Report not appearing in app

Fabric Dataflow Gen 2

dataflow gen1

Dataflow metadata

connection to dataflows