Forum Discussion
Date data/datetype changes on refresh in PowerBI service
Hi all, I have a situation where I need some help with, I hope someone has a solution for it. I have created a report based on a date type DD-MM-YYYY. Sidenote: and change this to a diffe...
I solved my issue....
From PowerQuery I had transported the date as a text value and transformed the text value to a date in PowerBi desktop. which caused that in some cases the day and month where swapped.Right now I have set the field type to date in PowerQuery and my issue is solved.
Kind Regards,
Ramon
amitchandak ,
Thank you for your fast response, I have checked the link and tried to setup de right settings. But it didn't solve my issue:
I have checked the PowerBi service setting its on Default (browser language)
The Chrome settings are on Englisch (UK) which should have DD/MM/YYYY
And I have cleared cache and published/ tried again.
Any other ideas?
See images bellow: