Forum Discussion
Date format change when deploying through pipeline
Hi EasyChreasi ,
I have a couple of ideas/suggestions to look into.
Non-standard ISO dates (i.e. a date format other than yyyy/mm/dd) can be very unpredictable in Fabric/Power BI.
What is your source date format? Are they from a csv? It might be treating non-ISO formatted dates as strings when converting to a date in Power BI and is not treating the dates consistently across workspaces. Consider forcing an ISO date (yyyy/mm/dd) in Power Query and then setting the date to your preferred date format in desktop visual formatting.
Also another thing to look at, which might be a long shot, but is the locale/language the same between dev and test workspaces? If the locale settings are different that might cause the issue you are seeing.
Chris Andrews, Senior Data Analyst
www.linkedin.com/in/dr-christopher-andrews
Community SupportHi EasyChreasi,
Thank you for reaching out to Microsoft Fabric Community.
Thank you tayloramy and chris_andrews for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the response's provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
Community SupportHi @EasyChreasi,
We wanted to kindly follow up to check if the response's provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa