Would like to get a date field from my database rather than a datetime field

[akhaliq7]

Would like to get a date field from my database rather than a datetime field, When I am using a native query (I know this is not recommended), I don't want to get a datetime field as I can't then use it with a date table. using power query will slow down the native query as query folding is off (query folding does not work with an oracle db I think only ms sql server when using native queries). I have tried using trunc in my native query but all that does is shows the time as 00:00:00 it doesn't remove it.

[SpartaBI · Accepted solution]

@akhaliq7 it's ok this way. If you have it with 00:00:00 you can use it in a date dimension table. In fact the tabular model stores it anyway as datetime, just the formatting is different. You can then change the type for readability in the table model.
As long that you have a unique row per date and that your date dimesnion will have full years and consecutive days, you will be fine

      

Showcase Report – Contoso By SpartaBI