Date Column Error

[manouchehr19346]

Hi everyone,

I have copied the dataflows from one account to another account and now I am using the dataflows to create report in power BI.

There are some columns related to the dates which have normal date format, and not localdate detting, and there is no error in the table. Now I am using the table to create a new table in power BI and merge it with another table, which has no date column. I merged the table, and when I try to expand the merged columns, I get an error of the invalid date value. The date values before merging are ok and show no error, but when I merge them, I get the error:

DataFormat.Error: The specification for a date value could not be analyzed.
Details:
 31.08.2018

Just to mention one more time, the date values have no error before merging, and the second merging table has just two columns which are not dates, they are some numeric and text columns. I have also changed the dateformat to the loca seting but when doing this, some rows of the dates produce error, so I just used the normal date format.

I would appreciate if anyone coluld help me with it, it is really annoying.

Best Regards,

Manouchehr

[bhanu_gautam]

@manouchehr19346 , You can try below methods to debug this error occurs when Power BI is unable to interpret the date format,

Before merging, ensure that the date columns in both tables are in a consistent format. You can use Power Query to transform the date columns to a common format.
Convert Date Columns to Date Type:

In Power Query, explicitly convert the date columns to the Date data type. This can help Power BI understand the date values correctly.
To do this, select the date column, go to the Transform tab, and select Data Type -> Date.
Check for Invalid Date Values:

Sometimes, there might be invalid date values that are not immediately apparent. You can filter the date column to check for any anomalies.
In Power Query, you can add a custom column to check for valid dates using a formula like = try Date.From([YourDateColumn]) otherwise null. This will help you identify any rows with invalid date values.

[manouchehr19346]

Hi and thanks for your response. The second table that I am using to merge has no date column. In fact, the merging columns are some buildung codes and not dates.