Forum Discussion
Power Automate does not export the column date from a table in power bi to Excel
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 ?
Specify the actual date, not the hierarchy. In general you do not want to use Auto Date Time.
6 Replies
- lbendlinSuper User
Specify the actual date, not the hierarchy. In general you do not want to use Auto Date Time.
- AnonymousNot applicable
It worked, thank you.
- AnonymousNot applicable
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
- lbendlinSuper User
Service dates are in UTC.