Forum Discussion
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...
Do you have a date table in the model (and is there a relationship to 'Response Delivered')?
The query editor just changes the data type. After data load, in Data View, click on the column and the Format tab to change it to your desired format.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat