Forum Discussion
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 In PowerBI desktop becamePublished this after publish and sharing on PowerBI portal.
Data type is TEXT for these fields.
How can I fix this?
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
2 Replies
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