Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cannot convert value " of type Text to type Integer

I'm importing data into Power BI and I have "Duration" column which stores duration in seconds. I want to convert it to minutes so I've created a new column and used the following function: ROUNDUP ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    That must be mytable[Duration] is a text column, means there must be some text format value in it.

    Please change the data type of this column into number as below:

    Then you filter which row is error.

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

HI, Anonymous 

That must be mytable[Duration] is a text column, means there must be some text format value in it.

Please change the data type of this column into number as below:

Then you filter which row is error.

 

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your tip v-lili6-msft! I've changed the data type to decimal number in power query editor and I didn't get any errors but I had some blanks, which I removed in filter >> remove empty.

My new column is now working as expected.