Date time preview for data flow error

Question

Date time preview for data flow error

Lotus88 181

Hi,

Have anyone encounter the issue that a date time preview for CurrentUTC() is not working?

It is working in the past but now suddenly not working anymore.

User's image

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Smaran Thoomu 35,375 Microsoft External Staff Moderator

Hi @Lotus88
Welcome to Microsoft Q&A platform and thanks for posting your query here.

I tried reproducing the issue on my end, and the currentUTC() function is working fine now. It might have been a temporary issue. Can you try again and see if it's working for you as well?

User's image

However, when I used fromUTC(currentUTC(Sys_dt), 'Asia/Singapore') (where Sys_dt is a column name), it worked fine.

Can you check if your expression is missing a required parameter or if you need to pass a column reference? Let me know if you need further assistance!

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Lotus88 181 Reputation points

2025-03-04T09:45:52.39+00:00

It is still not working. I don't understand this error.
Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-03-04T10:26:21.4466667+00:00

Hi Lotus88

Thanks for getting back. I was able to reproduce the issue you’re facing. The function currentUTC() requires a string parameter to work correctly in this scenario. Try updating your expression like this:

fromUTC(currentUTC('yyyy-MM-dd HH:mm:ss'), 'Asia/Singapore')

This should resolve the issue. Let me know if you’re still seeing any errors!
Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-03-04T14:59:25.2466667+00:00

Lotus88 We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

We have provided a detailed answer which has clear steps for which you are looking for. If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

Smaran
Lotus88 181 Reputation points

2025-03-05T02:32:20.3933333+00:00
Hi,

Finally, it is working. Thank you!

But I have another problem. I want to pass in a parameter to the data flow.

This variable is current UTC value.

@formatDateTime(utcNow(), 'yyyy-MM-dd HH:mm:ss.fff')

In my data flow, I have a derived column. However, I keep getting null value on the result, can you advise? My sink column is timestamp data type.

fromUTC(toTimestamp($p_sysupdate_dt, 'yyyy-MM-dd HH:mm:ss.SSS'), 'Asia/Singapore')
Lotus88 181 Reputation points

2025-03-05T03:23:51.6233333+00:00

All my loading are ok but I keep getting this error after I implemented the derived column.

Error: Job failed due to reason: com.microsoft.dataflow.Issues: DF-ARG-007 - store is not defined - [564 737],EXE-0001,Dataflow cannot be analyzed as a graph, source( ) ~> MainSource DF-ARG-007 - store is not defined - EXE-0001,Dataflow cannot be analyzed as a graph,[564 737], source( ) ~> ChangedQuotes DF-EXPR-009 - Column quote_item_id not found. The stream is either not connected or column is unavailable - [315 62 463 564 737],EXE-0001,Dataflow cannot be analyzed as a graph, MainSource, ChangedQuotes join( ) ~> JoinSourceAndChgQuotes,[463 564 737] DF-EXPR-010 - Column 'region' used in expression is unavailable or invalid. - EXE-0001,[315 221 320 463 564 737],Dataflow cannot be analyzed as a graph, JoinSourceAndChgQuotes select( ) ~> SelectSourceFields DF-EXPR-010 - Column 'form_number' used in expression is unavailable or invalid. - EXE-0001,Dataflow cannot be analyzed as a graph,[315 227 320 463 564 737], JoinSourceAndChgQuotes select( ) ~> SelectSourceFields DF-EXPR-010 - Column 'quote_number' used in expressio
Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2025-03-05T05:07:15.23+00:00

Lotus88 The scope of your current question seems to be different from the original query. I recommend creating a new thread on the forum with as much detail as possible about your issue. This will ensure better visibility and help the community assist you more effectively.

If my response helped resolve your issue, kindly Accept Answer to help others facing a similar problem. Looking forward to your update!
Lotus88 181 Reputation points

2025-03-05T06:03:02.04+00:00

Ok done. Thank you!

Unable to update datetime to sink via data flow

Share via

Date time preview for data flow error

0 additional answers

Your answer