Forum Discussion

sp8's avatar
sp8
Helper 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
sp8's avatar
sp8
Helper II
7 years ago

I'm using the latest version.

Here is my custom column. It's really simple.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi sp8 

Sorry, I still can't reproduce yout problem.

I can change the data type to number.

Maybe you can share me with the code to check clearly.

 

Or you could create a measure directly:

Measure = SUM('Sheet2$'[amount])/24

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • sp8's avatar
    sp8
    Helper II
    7 years ago

    Sorry if I wasn't clear. I can manually change it to number type.  My only issue is with the automatic behavior.

    I'm saying that when I connect to the table, the type is number and then when I add the new (/24) column, PBI automatically changes the type from number to text. This is why I have to manually change it.

    But that doesn't make sense as it was a number type before, and then I did a number function to it (division), so why would it change to  a text type after that?