Two identical datetime columns. Different appearance in Power BI with a live connection to SSAS

[Tokotor]

Hello,

I have a problem with datetime formats in Power BI Desktop.

I have a live connection with SSAS database and have one table with two columns that are both a datetime format.

The strange thing is that Power BI only shows the date by one and the date + time on the other.

I can't change the format because of the live connection but that shouldn't be necessary because there both in the datetime format.

Both columns are formatted as dd-mm-yyyy hh:mm:sss

Power BI changes that for one column to dd-mm-yyyy and the other one to dd-mm-yyyy hh:mm

Both of them should be dd-mm-yyyy hh:mm

Is this a known problem or how can I fix this?

[FarhanAhmed · Accepted solution]

Are you sure that both date Format defined in SSAS are same ?

Try explore these dates in excel and see what results you are getting.

[Tokotor]

I found the problem. In SSAS in Visual Studio it changes the data format from general to custom. I don't know why. 

In SSIS in Visual studio the format is the same for all the date colomns.

For some reason Visual Studio changes the data format for some colomns. Now it works so thanks. The next problem i need to find out is why Visual Studio changes the data format.

[amitchandak]

@Tokotor , try to check data type in power query. You can chnage format from the format ribbon.

 

[Tokotor]

@amitchandak  I can't change the format because i work with a Live Connection to a SSAS database.

[Anonymous]

Try adding a column next to it and use Dax to change the format.