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

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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'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.