Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      It worked, thank you.

    • Anonymous's avatar
      Anonymous
      Not 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