Forum Discussion

Wayfarer's avatar
Wayfarer
Advocate I
6 years ago

DateTime format error getting data from PBI DataFlow

Hi all.  Hopefully someone has come across the same issue I'm finding and has some advice.   I have created a Power BI dataflow.  It refreshes successfully.  There are date fields which show correc...
Need Help
romoguy15's avatar
romoguy15
Helper IV
5 years ago

Hey Wayfarer , did you ever figure out a solution to this? I am also having the same issue.

  • Wayfarer's avatar
    Wayfarer
    Advocate I
    5 years ago

    Hey.  I'd forgotten about this post!  I haven't tested the DataFlow region for English (New Zealand) recently, I assume it's still "broken" for datetime columns.  I've just used English (Australia) instead, no difference in the report UI.

     

    Note that regional settings in PBI desktop didn't seem to make any difference.  It was just regional settings in the DataFlow onine.

    • KNP's avatar
      KNP
      Super User
      4 years ago

      Hey Wayfarer, 

       

      I'm curious to hear your results if you have time to revisit this.

      I'm not keen to use other similar locale settings as a workaround unless I have no choice.

      I'm seeing a lot of weird behaviours for Dataflows in the Service recently, not least of which is the dates.

       

      e.g. I had a generic changed type converting a column to datetime, it worked for almost all rows in the Dataflow but decided to turn some to null. It. Makes. No. Sense. ğŸ˜•

      I then removed the type change and explicitly converted using locale and those nulls formatted correctly as dates. I then removed that locale type conversion and used a generic 'detect data types' and ALL dates converted correctly. No nulls.