Unanswered

Automate Power Bi data to excel and getting strange date formate

(0) Share

Report

Posted on by WolfDog23

Hi,

I'm very new at power automate, but I created a share point template with a table to export data from a power bi visual. The issue I'm having is the date fields, which has been formatted in the template to match the visual (Day, MM,DD,YYYY) populate in a strange way as seen below. Even after the data is exported, I can't format it in anyway. I can't seem to fix this problem. Appreciate any help.

Power BI visual:

When exported to excel:

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

This is not a strange format. It is ISO8601, by far the best datetime format to avoid ambiguity.

Note that the Power BI service runs on UTC.

Was this reply helpful? Yes No
WolfDog23 5 on at

Like (0)

Report

@lbendlin Thank you for that information. I guess by strange I meant a format not typically used. As I mentioned I tried a few changes to see if I could get it to replicate what I have in Power BI. Are you familiar with a way to have the date formatted differently? I'm using this as a way to notify separate departments of things coming their way week by week and they requested it be in excel. While it may be a good format to use for any confusion, they really on need-to-know what day that should be expecting. Again, appreciate the help.

Was this reply helpful? Yes No
Verified answer

lbendlin 8,474 Super User 2025 Season 2 on at

Like (1)

Report

You can use formatdatetime() to convert the date into a formatted string according to your needs.

Was this reply helpful? Yes No