Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

transformation of date

hi, in the fabric dataflow, there is a column of type date, i.e. 30/03/2024 I created a xolumn by example from this column with format of 2024-03-30 and I called this new column: date_formatted B...
Dataflows
  • miguel's avatar
    miguel
    2 years ago

    Data Formatting is something that is handled by your browser settings. Typically in a Data Preparation tool what's crucial is that the correct data type is recognized. If you load this to a Lakehouse, then you might want to check how things are being formatted there or how you want to format data in your reporting layer.

     

    Dataflow / Power Query doesn't have any specific setting to match a particular data formatting for a particular data type. We just inherit and respect whatever setting you have on your browser to display the data following that configuration.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Thanks for using Fabric Community.
I can also find by default it is converting to this format - "30/03/2024" for type date.

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.