Issue with date format conversion

[Fazelmann]

Date conversion fails for text DD.MM.YYYY when using Swedish locale (sv-SE), but works with German locale (de-DE). Data has been validated with Trim, Clean, and character code analysis. Data from excel file. PowerBi updated, region checked both on Windows and PBI. 

DD.MM.YYYY is converting correct to YYYY-MM-DD when German is used, however when Swedish locale (or just date format) is used some rows convert correctly while others gets "error". 

Anyone with similar problem and possible solution?

[grazitti_sapna · Accepted solution]

Hi @Fazelmann ,
Please try using In, the simplest fix is to always use Change Type With Locale → German (Germany) for DD.MM.YYYY formatted data, then your dates will reliably convert to the proper YYYY-MM-DD format inside Power BI.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!