Forum Discussion
Community ChampionDate format changed when published to PBI Service
, Try to clear the cache of Desktop pbix,Go to File-Options and Settings - Options , Under Global, select Data Load and select "clear cache" under "Data Cache Management Options" and select "clear cache" under "Q&A Cache Options" and select "clear cache" under "Folded Artifacts Cache Options". Then ,re-publish it.
Community ChampionIt sounds like the date-column is being treated with an US culture somewhere in the transition from the source to service, which then results in the incorrect format when the data get the european culture in service.
You can try something like this:
I haven't tried it myself so i dont know if it works, but the idea is to tell service to expect an US culture and through that correctly format the information.
Hope this helps,
J
Community ChampionNo I dont think there is problem with US culture because only few valaue gets changed not a complete column. showing error only for Jan month. Is there any other way It can be fixed?
Hello, I'm facing the same problem as you did.
Did you find a solution ?
Thank you