Forum Discussion
SharePoint List dates (UK format) being misinterpreted in Power BI
Answer: The problem arises when Power BI ingests the data: Power Query applies type detection based on the regional settings of your operating system (or the Power BI Service environment). If that defaults to US English, dates get misinterpreted as MM/dd/yyyy even if SharePoint shows them as dd/MM/yyyy.
Resolution Steps:
Set your OS regional settings to UK (dd/MM/yyyy) so Power Query inherits the correct locale.
Remove auto “Changed Type” steps in Power Query, as they often lock in US format.
Explicitly convert using locale: in Power Query, use Change Type → Using Locale → Date → English (United Kingdom) as the first applied step.
Check Power BI Service regional settings (workspace → Settings → Regional Settings) to ensure they match UK format, otherwise refreshes may revert to US defaults.
Documentation Link for Reference:Set a locale or region for data (Power Query) - Microsoft Support
Answer: The problem arises when Power BI ingests the data: Power Query applies type detection based on the regional settings of your operating system (or the Power BI Service environment). If that defaults to US English, dates get misinterpreted as MM/dd/yyyy even if SharePoint shows them as dd/MM/yyyy.
Resolution Steps:
Set your OS regional settings to UK (dd/MM/yyyy) so Power Query inherits the correct locale.
Remove auto “Changed Type” steps in Power Query, as they often lock in US format.
Explicitly convert using locale: in Power Query, use Change Type → Using Locale → Date → English (United Kingdom) as the first applied step.
Check Power BI Service regional settings (workspace → Settings → Regional Settings) to ensure they match UK format, otherwise refreshes may revert to US defaults.
Documentation Link for Reference:Set a locale or region for data (Power Query) - Microsoft Support