Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hmbedford
Frequent Visitor

Dataflow Refresh Error: DateTime operation failed because the resulting value falls outside the rang

Hi

 

I have a dataflow setup which pulls from an onprem SQL server (Via gateway). The table has a Year, Month and Day column that I am using to build a date string:

 

Table.AddColumn(#"Changed column type", "Date"each #datetime([Year], [Month], [Day], 000)),
Table.TransformColumnTypes(#"Added custom", {{"Date"type datetime}}, "en-GB")
 
I am using this column in the Incremental Refresh Settings, but results in a refresh error that states:
 
Error: PipelineException: The DateTime operation failed because the resulting value falls outside the range of allowed values. .. RootActivityId = e97cd39f-2f6b-415b-b298-788aba85cab2.Param1 = PipelineException: The DateTime operation failed because the resulting value falls outside the range of allowed values. Request ID: be919842-9f3f-bbd6-69eb-596101612cf9.
 
I have the project options set Local 'English (United Kingdom)' and converted the DateTime field to en-GB.
 
Hopefully someone has the anwser 🙂
 
Thanks
Hayden
1 REPLY 1
lbendlin
Super User
Super User

Some questions: why are you specifying datetime but only feed it a date value ? Is that for incremental refresh?

And what's the reason for specifying the en-GB locale?  That shouldn't really be necessary?

Note that you are not creating a string, you are creating a datetime value.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors