Dataflow refresh error Date/Datetime

[Banzai]

Started getting this error on an old dataflow as of 14-Jun-2021. No changes made.

Error: Expression.Error: We cannot apply operator < to types Date and DateTime.

Operator = <

Left = 5/1/2020 12:00:00 AM

Right = 9/30/2020 11:59:59 PM

[judgejebber]

Same here!

[v-chuncz-msft]

@Banzai 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Keep-getting-quot-Expression-Error-We-cannot-apply-operator...

[Banzai]

@v-chuncz-msft

Thanks, but the problem is not the same. Both values are already datetime as can be seen from the error message. However, for some reason the dataflow sees one as a date, whereas Desktop runs the query just fine.

[EMaguire]

I am also getting the same error in dataflows, also only since 14-Jun-2021; the same dataflows have refreshed successfuly previously. The refresh failures are arising from linked entities. All fields are already formatted as type date so there should be no error. Re-confirming the field format as type date in the query step before the one which creates the error seems to fix the problem - but this should not be necessary.

[Anonymous]

We are experiencing a similar error with dataflows that were running before. Our is: Error: Expression.Error: We cannot convert the value #datetime(2019 9 26 0 0 0) to type Date. ..

[InsightBob]

Same issue.  ihave raised a support ticket, will report back here.

possibly related to a recent service outage

[Anonymous]

Yep same issue here! How annoying!

[Banzai]

The only workaround for me was to branch the query into a separate dataflow, which ran without a hitch.

Wrapping the columns into DateTime.From() or re-applying Transform.ColumnTypes() did not work with the original linked entity, but referencing the same entity in another dataflow worked.

[InsightBob]

Still working with MS on solution.  We're seeing this issue with downstream dataflows using linked entities,  we've found that if you diable the load on the linked entities things refresh fine,  this isn't feasible for us though - would mean sheduling all dataflows.

We've had this problem before in 2020

[steveplatz2]

I'm seeing this same issue also. Dataflow had been working fine for months and then started failing on 6/11/21. I thought I somehow inadvertently change something with it when looking at it the other day, so I went back and started from scratch, building everything step by step and confirming data along the way. Even with two date-typed columns, I get the reported error. Everything loads (and compares) fine in the preview screen.