Forum Discussion
Anonymous
5 years agoNot applicable
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...
- Anonymous5 years ago
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
Anonymous
5 years agoNot applicable
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