Forum Discussion
Dataflows date and import issues
Hi jcullum ,
Locale property is used to help power bi to recognize record values that diff from your device region format, it does not mean the display format. (e.g your date value stored as 'UK' date format but your system region is 'US', you can modify locale to 'UK' to help recognize 'UK' date values)
For data column type recognize issues, you can enter to query editor and manually fixed this in 'change type' step.
In fact, this optional parameter will include when you use on desktop side. (it will auto-generated based on the corresponding connector) It seems like power bi dev team forgot to add these parts on the dataflow side. (you can contact them and report this issue)
Regards,
Xiaoxin Sheng
Thanks for the the reply.
A Couple of things. I don't know what you mean by my region being US. As far as I know my region is AU, not US, my regional settings on my pc are australian. The dataflows are in the is SouthEast Australia Azure cloud.
With respect data column, I did state that i am already changing the type, the bigger concern is i am setting it to Date and it is being stored in the entity as DateTime.
Unfortunately i tired to submit a ticket but it didn't work, i need my organisation to provide me with access. I will be following it up today.