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
Advocate IEDIT: Okay that wasn't the problem. Looks like PBI service has a different (smaller) set of built in date formats than PBI desktop. I got the dates to format the way I wanted by selecting "Custom" for the date format in Desktop, building the format manually (e.g "dd MMMM yyyy") and republishing the report.
Hey,
I'm a UK user.
I think you're right that this is the problem, but I haven't managed to fix it yet. Really frustrating issue because the dates are truncated and no longer fully visible in the report in the service.
I've noticed that whenever I use Power Query Online (i.e. publishing dataflows) and apply any type transformation that involves a date field I have to explicitly specify the correct locale, e.g.
Table.TransformColumnTypes(#"label",{{"fieldName", type date}, "en-GB"))}
Otherwise the dates are transformed as US format, which just breaks the query.
Scatching my head here. I'm guessing there is still some part of the dataflow where the date is being treated as US format. Do you know of a more global place I could tell the service to expect GB formatted dates?