Power Automate does not export the column date from a table in power bi to Excel

[SamiaSouissi]

Hello everyone, 

I have created a Power Automate flow to export data from Power BI to Excel following the instructions in this video: https://youtu.be/cT4JdClkLh8?si=m4VMeRBncXje_jzi. The table to export contains 5 columns, one of which is a date column. This screen displays the data to be exported.

After launching the flow, the resulting table in Excel displays, but the data in the date column is messing 

Do have any ideas please ? 

[lbendlin · Accepted solution]

Specify the actual date, not the hierarchy.  In general you do not want to use Auto Date Time.

[SamiaSouissi]

I have an additional issue. I don't have the exact date, but it occurred the day before : 

For example for the first row, i should have : 01-12-2016 and not 30-11-2016

[lbendlin]

Service dates are in UTC.

[SamiaSouissi]

Can you give me more details please, is there a solution to have the exact date without this format ?

[lbendlin]

ISO8601 is the best format you can get.  Convert it to your local format as needed.

[SamiaSouissi]

It worked, thank you.