Datetime column in SQL Server not displayed the same type in Power BI

Hi ahmed_MEJRI ,

In query editor, select both of these columns, right click and MERGE.

This will merge both of these columns.

Then click on the merged column and chnage it's datatype to datetime format from the top ribbon under TRANSFORM.

Consider following example:

Select both of your columns Date and Time:

Right click and select MERGE as highlighted above.

A window appears, enter the following values:

Once you hit OK, you get the following:

Select your merged column - DateTime Value

Then click on Transform on top ribbon and modify datatype to DATETIME as shown below:

You get your merged Datetime column as shown:

Hope this helps.

Thanks,

Pragati