Forum Discussion
Issue with date field in direct query mode
Hi , I have 2 tables-Table A and Table B that are joined by fileid column. I am displaying the data in Table A in a table chart. In another table visual I am displaying the data from Table B. My aim...
I wrote a sql query for Table B, and converted the date field to varchar.. Strangely it worked after converting the date field to text.
Regards,
Priyanga
HI Anonymous
In Import query mode all the fields are imported as text, what ever it may be.
On the power query editor or on the 'Column Tools' option of the desktop mode once you chage the type to date yor filter will start working. I have the same scenario and it works after changing the data type.
@Pranit, Query editor has detected it as a datetime field. Its not in text
I wrote a sql query for Table B, and converted the date field to varchar.. Strangely it worked after converting the date field to text.
Regards,
Priyanga