Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column Type Mismatch Between Desktop and Query Editor

I used the power query editor to change a list of dates from the auto generated text column type to the corrected short date format, but for some reason it does not update on the main Power Bi Deskto...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    Do you have a date table in the model (and is there a relationship to 'Response Delivered')?

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

 

You may use Date.FromText to convert the data type from text to date and give the column a 'Date' data type. You can add a new step as below.

Table.TransformColumns(#"Changed Type",{"Date",each Date.FromText(_),type date})

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    The formula you sent gives me an error (and I did adapt it for my column names when I tried it), but the data is already listed as a date format on the editor. The main screen where I am building the dashbaord still will not show the "response delivered" data as a date though even though I've done this for 2 of the other columns here and they worked perfect like normal.

     

    Any help is greatly appreciated! 

     

     

     

    • HotChilli's avatar
      HotChilli
      Community Champion
      6 years ago

      Do you have a date table in the model (and is there a relationship to 'Response Delivered')?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Yes this fixed the issue, thank you so much HotChilli !!