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
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi sp8 

I can't reproduce your problem on my side.

Do you use the lastest version?

Could you show some screenshots and more other details (eg. code in Advanced editor)?

 

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

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?