Forum Discussion
Issue with date format conversion
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?
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!
1 Reply
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!