DIRECTQUERY from REDSHIFT changes int to text

[fdkza]

Hi 

I am importing a dim-time table from redshift that contains all the hours their respective formats including am/pm variants. Powerbi does not recognise int = 0 as a whole number and changes the colum to text as well as changing my time format to text. Is there anyway i can force powerbi to not autodetect datatypes for that table ? 

[v-yulgu-msft]

Hi @fdkza,

You can change the data type to Date in Power BI desktop under Modeling tab.

Besides, what is the format of date values in source dim-time table, can you show us an example?

Regards,

Yuliana Gu

[fdkza]

The issue with that is that it changes the directquery to import mode which is something that I dont want.

The fileds in question looks like follows. both of them get imported as text value which means that i cant sort them properly on a chart  

TimeHour (Int)	TimeFormat (time)
0	00:00
1	01:00
2	02:00
3	03:00
4	04:00
5	05:00
6	06:00
7	07:00
8	08:00
9	09:00
10	10:00
11	11:00
12	12:00
13	13:00
14	14:00
15	15:00
16	16:00
17	17:00
18	18:00
19	19:00
20	20:00
21	21:00
22	22:00
23	23:00

[v-yulgu-msft]

Hi @fdkza,

You may hit the limitations of Direct Query. Please make sure the data type of time fields in data source is set to Date/Time.

Best regards,

Yuliana Gu