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 t...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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