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 e...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Service dates are in UTC.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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