Forum Discussion

Sushain's avatar
Sushain
Frequent Visitor
4 years ago
Solved

Query regarding Date Format

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.

Need Help
  • Sushain's avatar
    Sushain
    4 years ago

    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.

9 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Sushain 

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

    • Sushain's avatar
      Sushain
      Frequent Visitor
      4 years ago

      Hi tamerj1,

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

       

    • Sushain's avatar
      Sushain
      Frequent Visitor
      4 years ago

      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.