Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hy,
I'm new in Power BI and in this forum but currently didn't find an appropriate solution 🙂
I want to get the actual date and time (UTC) into a ISO 8601 standard text with format yyyy-mm-ddThh:mm:ss:Z.
I need this for a dynamic API url request. I tried with DateTimeZone.utcnow() and the time.totext function but don't get it.
Thanks for help,
best regards,
Andreas
Solved! Go to Solution.
Hi, @alitzellachner
try using this way.
let
CurrentDateTime = DateTimeZone.UtcNow(),
ISOFormat = DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ")
in
ISOFormat
DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ") formats this date and time according to the ISO 8601 format.
Proud to be a Super User!
Thank you- worked
Happy to help.
Proud to be a Super User!
Hi, @alitzellachner
try using this way.
let
CurrentDateTime = DateTimeZone.UtcNow(),
ISOFormat = DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ")
in
ISOFormat
DateTimeZone.ToText(CurrentDateTime, "yyyy-MM-ddTHH:mm:ssZ") formats this date and time according to the ISO 8601 format.
Proud to be a Super User!
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 5 | |
| 4 | |
| 3 |