Forum Discussion
DIRECTQUERY from REDSHIFT changes int to text
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 ?
3 Replies
v-yulgu-msftMicrosoft Employee
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
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
