Forum Discussion

sp8's avatar
sp8
Icon for Helper II rankHelper II
7 years ago

direct query automatically changes data type- bug?

Hi. I'm wondering if this is a bug or intentional and if there's a smarter workaround.   I have a # of hours column in direct query. Power BI recognizes that it is a number. Through the query edit...
General Comment
Show and Tell
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi sp8 

Do you add a custom column or a conditional column?

 

Best Regards
Maggie

  • sp8's avatar
    sp8
    Icon for Helper II rankHelper II
    7 years ago

    I'm making a custom column, with the formula [days]/24