DateFormat Error in Power BI using Sharepoint connection

Hi msft-cap 

One of the columns defined as Date/Time likely contains values with inconsistent or invalid formatting, which causes Power BI to throw a [DataFormat.Error] when trying to parse them.

This usually happens when:

• The column includes values with leading/trailing spaces (e.g., " 01/02/2024").

• The date format in the source file differs from the expected format in Power BI (e.g., U.S. MM/DD/YYYY vs. U.K. DD/MM/YYYY).

• Some values are not valid dates at all.

You have two options to resolve this:

1. Fix the source file – If possible, open the SharePoint file and clean up the problematic column by removing extra spaces and making sure the date format is consistent.

2. Handle it in Power BI – In Power Query:

   • Use Text.Trim() before converting the column to date.

   • Use Using Locale when converting to date to match the original date format (e.g., English (United States) or English (United Kingdom)).

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Hi msft-cap ,
Just  wanted to check if you had the opportunity to review the information provided by Ritaf1983 ?.
If her response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you

Hi @msft-cap ,
Just  wanted to check if you had the opportunity to review the information provided by @Ritaf1983 ?.
If her response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you

Hi  msft-cap ,
Thanks for reaching out on Microsoft Community Forum!
If your issue still persists, please consider raising a support ticketTo raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Hope this helps!