Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Incorrect local date - Australian format

Hi, (Power BI version - Sept 2018 desktop)   I am importing data from SAP BW. I have a date field in the source which imports as text. it comes as dd.mm.yyyy eg for 28th August 2018 it is 28.08.2...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    I found you could change the type in the Data tab. Please do it in the Query Editor that is a data washing tool. You will find it easy now. Please refer to the snapshot below.

    Incorrect-local-date-Australian-format2

     

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Did you try to change the option "Regional Settings"? It's used to detect the format of the data source. 

Incorrect-local-date-Australian-format

Best Regards,
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-jiascu-msft.

    Thanks for the reply.

     

    Yes, I have ensured my setting is English (Australia)

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      I found you could change the type in the Data tab. Please do it in the Query Editor that is a data washing tool. You will find it easy now. Please refer to the snapshot below.

      Incorrect-local-date-Australian-format2

       

       

      Best Regards,
      Dale

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Thanks Dale.

         

        This works.

        I was changing the format in the data modelling tab.

         

        Now I will do it in the query editor