Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Mimi_Ibrahim
Helper I
Helper I

Checking Date Format from the Source File

Hi Everyone,

 

I'm using Power Bi as a tool to check for data error.

Can you advise how I can check whether the data in the source file (MS Excel) is in DD/MM/YYYY?

 

Currently Power BI automatically detect the date and convert it to dd/mm/

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

Hi @Mimi_Ibrahim

 

I would suggest you check data format in Excel file directly. 

In Power BI desktop, when we import data from the Excel file, the date format is based on the regional settings in Power BI desktop: https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions#choose-the-locale-fo...

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Qiuyun Yu, 

 

Are you saying that there is no way that the checks can be done via Power BI?

 

@Mimi_Ibrahim 

Not sure if checks can be done. But have you tried using the Datevalue() function

I havent tried using Datevalue() function. But I do noticed if the date format is invalid, it will trigger an error when I refresh the data source. It is a good check, but it can be tricky if there are hundreds of fields to check.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.