Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Text column format with data different after publish - converted to date time

We have extensive conversion done in M to display timeframe in YYYY-MM-DD format, because no such option exist.   Suddenly it started to go wrong after publish: Column in PowerBI desktop beca...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    It seems like your date values stored as text format, but it seems to recognize and transforms to date value when you publish to power bi service side.

    Have you tried to remove the old version publish it to confirm if this scenario still appears on your side? In addition, where are your data hosted? It may be caused by specific data region service.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng