Automate Power Bi data to excel and getting strange date formate

Like (0) Share

Report

Posted on 28 May 2023 05:18:39 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:

All responses (3)

Answers (1)

Verified answer

lbendlin 8,111 Super User 2025 Season 2 on 29 May 2023 at 19:32:50

Like (1)

Report

Re: Automate Power Bi data to excel and getting strange date formate

You can use formatdatetime() to convert the date into a formatted string according to your needs.
WolfDog23 5 on 29 May 2023 at 14:37:09

Like (0)

Report

Re: Automate Power Bi data to excel and getting strange date formate

@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.
lbendlin 8,111 Super User 2025 Season 2 on 29 May 2023 at 00:05:32

Like (0)

Report

Re: Automate Power Bi data to excel and getting strange date formate

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.