Query regarding Date Format

[Sushain]

Hello All,

I am working on a project and I am stuck at a point. Plz help me out. My doubt is I am fetching a dataset from salesforce into power bi via google sheet. That dataset has a date column in the format dd/mm/yyyy in google sheet. When its loaded in Power Query the format remains same but when it comes loading into Power BI the format changes. For example in Power Query some dates in dd/mm/yyyy format like 07/04/2022 in Power Query would change to mm/dd/yyyy taking 07 as month number and 04 as date i.e 04th July, 2022. Few dates don't change their formatting whereas few do. Plz help me out. I hope I have cleared my confusion.

Thanku in advance for helping me.

[CNENFRNL]

Simple enough,

[Sushain · Accepted solution]

Thx @CNENFRNL for this solution but fyi this solution is not working. This is what I was facing but I have resolved my issue thx to @tamerj1 guidance. I didn't add "en-GB" command but still the problem got resolved.

[tamerj1]

Hi @Sushain 

you can use "Locale" to define UK or US format. Or otherwise change the regional settings of your system 

[Sushain]

Hi @tamerj1,

I am getting this error I did some transformations. Can u help me with this? How should I resolve it?

[tamerj1]

@Sushain 

Try first transform it into decimal then to date

[Sushain]

Thx @tamerj1 for your help. That didnt solve my problem. I treid doing as u said but it didn't work out. 

Again I did some other transformations and finally its resolved now.

Still Thanks for your help.

[Sushain]

Sure Let me try.

[KellyK]

Hi Sushain, 

please share how you resolved the issue for the community to learn. Thank you! 🙂 

Best, 

Kelly Kaye

[Sushain]

Sure @KellyK . I will share the solution.