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...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi Anonymous,

     

    There is a easiest way to change text column to date, you can set the Regional Setting in Power BI desktop as English (Australia), save the change and reopen the report. Go to Query Editor, select the date column, change it to Date type. 

     

     

    By the way, there is a October Power BI desktop released, you can update your desktop to this version 2.63.3272.40262. 

     

    Best Regards,
    Qiuyun Yu 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    7 years ago

    Hi Anonymous,

     

    You can insert a step to replace value # as blank before you change data type to date. Please select the date column, then click Replace Values, type below: 

     

     

     

    Best Regards,
    Qiuyun Yu 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-qiuyu-msft

 

Thanks for this.

 

some of the rows have a blank date in the database (which comes through as a "#")

Here is the error I receive.

 

"DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
    # "

 

How do I parse the # into a blank?

 

Cheers

Trev