Power BI Service refresh fails with date format error

[KM06]

Hi, 

I get this error message while publishing the report to service. Desktop refresh works fine. 
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We couldn't parse the input provided as a DateTimeZone value."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10032"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"6/30/2025"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: Labour Requirements.

I have tried everything discussed in the formum to related topics - formatting to date using locae, cleared cache, checked browser settings etc. 

I have been spending hours on this but with no luck. Can anyone please help me with this. 

Thanks

[v-echaithra]

Hi @KM06 ,

We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.

We truly appreciate your patience and look forward to assisting you further if needed.

Warm regards,
Chaithra E.

[v-echaithra]

Hi @KM06 ,

We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.

We truly appreciate your patience and look forward to assisting you further if needed.

Warm regards,
Chaithra E.

[v-echaithra]

Hi @KM06 ,

We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[v-echaithra]

Hi @KM06 ,

If your browser or Power BI Service is set to a different language like UK English, it might expect DD/MM/YYYY. You can change the Service language in your browser settings to match your data format.

In Power Query (Transform Data):

Select the problematic column.

Go to Transform > Data Type > Using Locale.

Choose:
Data Type: Date or Date/Time (as needed)
Locale: English (United States) or whatever matches the format.

Hope this helps.
Warm Regards,
Chaithra E.

[GilbertQ]

Could I recommend going into Power Query and changing your date time zone to date time and see if that resolves your issue.