I'm connecting direct query to SAP BW.
I have a date field that for some reason, pbi detect like text.
I try diferent regional settings, but everitame format it was text and it not possible to change it.
Because i'm in direct, i cant transform the column.
Have someone any idea?
Thanks a lot