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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
eroyle
Frequent Visitor

Token Comma Expected during custom step to convert to duration

Hello,

 

I got a custom query step from another post in here as I was getting an error for any duration that went over 12 hours (just 12, not 24 - error was "couldn't parse the Duration literal).  Found a solution that if I insert a custom step in place of the one to change the type to duration it should get rid of this error, but when I inserted it I continue to get this Token Comma Expected error.  Can anyone see where this error is?

eroyle_0-1655810435118.png

 

1 ACCEPTED SOLUTION

Hi @eroyle ,

I think the previous step name should be #"Replaced Value3" and not #Replaced Value3 since it has a space in the middle.
Please make this change and see if it fixes your issue.


Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

View solution in original post

4 REPLIES 4
eroyle
Frequent Visitor

Thank you!  This fixed the errors and I just had to replace null's with a 0.  🙂

rohit_singh
Solution Sage
Solution Sage

Hi @eroyle ,

I think there is a misplaced closing bracket (marked in blue). 

rohit_singh_1-1655818805901.png

 

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Hi Rohit!

That did change something, but now the Token Comma expected error has moved to the name of the previous step:

eroyle_0-1655820204167.png

 

Hi @eroyle ,

I think the previous step name should be #"Replaced Value3" and not #Replaced Value3 since it has a space in the middle.
Please make this change and see if it fixes your issue.


Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors