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...
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
Microsoft Employee
Microsoft EmployeeHi 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